This function returns an interval between two dates.
Parameters:
- Expression. Type: Date.
- Expression. Type: Date.
- Difference type. One of the following values:
- Second
- Minute
- Hour
- Day
- Month
- Quarter
- Year
DATEDIFF(DATETIME(2009, 10, 12, 10, 15, 34),
DATETIME(2009, 10, 14, 9, 18, 06),
"Day")
Result:
2
Next page: CURRENTDATE
