DATEDIFF

Difference between two dates in the specified unit.

Category: Date & Time Functions

Syntax

DATEDIFF(part, date, end)

Arguments

• part varchar [constant] Unit to measure the difference in, such as day, month, or year. Must be a constant expression.
• date temporal Date or timestamp value to evaluate.
• end temporal Ending date or timestamp value.

Returns

INTEGER — Returns the computed result as INTEGER.