aboutsummaryrefslogtreecommitdiff
path: root/sql/hive/src/test/resources/golden/udf_dayofmonth-1-ca24d07102ad264d79ff30c64a73a7e8
blob: 9e931f649914b00e31b13d109bd0592f27f277ee (plain) (blame)
1
2
3
4
5
6
7
8
9
dayofmonth(param) - Returns the day of the month of date/timestamp, or day component of interval
Synonyms: day
param can be one of:
1. A string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
2. A date value
3. A timestamp value
4. A day-time interval valueExample:
   > SELECT dayofmonth('2009-07-30') FROM src LIMIT 1;
  30