Skip to main content
Version: current [25.x]

Categories: Date/Time

DATEDIFF

Compares two dates or timestamps and returns the difference in days.

Syntax​

DATEDIFF(endDate string, startDate string) → integer​

  • endDate: A DATE or TIMESTAMP expression.
  • startDate: A DATE or TIMESTAMP expression.

Examples

DATEDIFF example 
SELECT DATEDIFF('2021-02-28', '2021-01-01')
-- 58
DATEDIFF example 
SELECT DATEDIFF('2005-04-09 12:05:55', '2003-02-01 11:43:22')
-- 798

Usage Notes​

If endDate is before startDate the result is negative.