/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_dayofmonth.q.out
text | 15 lines | 15 code | 0 blank | 0 comment | 0 complexity | a3f926838b70cac463b75fda01cfe77c MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: DESCRIBE FUNCTION dayofmonth
- PREHOOK: type: DESCFUNCTION
- POSTHOOK: query: DESCRIBE FUNCTION dayofmonth
- POSTHOOK: type: DESCFUNCTION
- dayofmonth(date) - Returns the date of the month of date
- PREHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
- PREHOOK: type: DESCFUNCTION
- POSTHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
- POSTHOOK: type: DESCFUNCTION
- dayofmonth(date) - Returns the date of the month of date
- Synonyms: day
- date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
- Example:
- > SELECT dayofmonth('2009-30-07', 1) FROM src LIMIT 1;
- 30