aboutsummaryrefslogblamecommitdiff
path: root/sql/hive/src/test/resources/golden/udf_second-2-3525f55f4f13253c42b3abaa53d77888
blob: 9dc38c3e79129da6859b5964eebe180405d166ed (plain) (tree)
1
2
3
4
5
6
7





                                                                      
    
second(date) - Returns the second of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
Example:
   > SELECT second('2009-07-30 12:58:59') FROM src LIMIT 1;
  59
  > SELECT second('12:58:59') FROM src LIMIT 1;
  59