datediff

Returns the number of "datepart" (day, month, year) units between "date_expression1" and "date_expression2".

Syntax

datediff ( {datepart} , date_expression1 , date_expression2 )

Example

datediff ( {yy} , 1984-01-01 , 1997-01-01 )

Result

13