Skip to main content

DATEDIFF

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.