aboutsummaryrefslogtreecommitdiff
path: root/sql/hive/src/test/resources/golden/udf_datediff-1-34ae7a68b13c2bc9a89f61acf2edd4c5
blob: 42197f7ad3e517e6f1bff26f53d64d0c0b3c9d46 (plain) (blame)
1
2
3
4
5
datediff(date1, date2) - Returns the number of days between date1 and date2
date1 and date2 are strings in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. The time parts are ignored.If date1 is earlier than date2, the result is negative.
Example:
   > SELECT datediff('2009-07-30', '2009-07-31') FROM src LIMIT 1;
  1