PageRenderTime 47ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

/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
  1. PREHOOK: query: DESCRIBE FUNCTION dayofmonth
  2. PREHOOK: type: DESCFUNCTION
  3. POSTHOOK: query: DESCRIBE FUNCTION dayofmonth
  4. POSTHOOK: type: DESCFUNCTION
  5. dayofmonth(date) - Returns the date of the month of date
  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
  7. PREHOOK: type: DESCFUNCTION
  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
  9. POSTHOOK: type: DESCFUNCTION
  10. dayofmonth(date) - Returns the date of the month of date
  11. Synonyms: day
  12. date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
  13. Example:
  14. > SELECT dayofmonth('2009-30-07', 1) FROM src LIMIT 1;
  15. 30