/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 

    

  1. PREHOOK: query: DESCRIBE FUNCTION dayofmonth
    2. 

  2. PREHOOK: type: DESCFUNCTION
    3. 

  3. POSTHOOK: query: DESCRIBE FUNCTION dayofmonth
    4. 

  4. POSTHOOK: type: DESCFUNCTION
    5. 

  5. dayofmonth(date) - Returns the date of the month of date
    6. 

  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
    7. 

  7. PREHOOK: type: DESCFUNCTION
    8. 

  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
    9. 

  9. POSTHOOK: type: DESCFUNCTION
    10. 

  10. dayofmonth(date) - Returns the date of the month of date
    11. 

  11. Synonyms: day
    12. 

  12. date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
    13. 

  13. Example:
    14. 

  14.    > SELECT dayofmonth('2009-30-07', 1) FROM src LIMIT 1;
    15. 

  15.   30
    16.