/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
- 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