Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following are the arguments, types, and specification of the DateDiff scalar function.
|
Function |
Arguments |
Type |
Specification |
|---|---|---|---|
|
DateDiff |
Return |
The difference between the Start date and time and the End date and time, in units of Interval. Negative if the Start date and time is after the End date and time. |
|
|
Interval |
The units over which to compute the date and time difference. MUST be one of the following: "Year", "Quarter", "Month", "Day", "Hour", "Minute", "Second", "Week". MUST be a Literal element. |
||
|
Start |
The start date and time. |
||
|
End |
DateTime or Time |
The end date and time. MUST have the same data type as Start. |