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.
Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate.
Syntax
DATEDIFF ( datepart , startdate, enddate )
Arguments
datepart
Is the part of startdate and enddate that specifies the type boundary crossed. The following table lists all valid datepart arguments.
| datepart | Abbreviations |
|---|---|
| year | yy, yyyy |
| quarter | qq, q |
| month | mm, m |
| dayofyear | dy, y |
| day | dd, d |
| week | wk, ww |
| weekday | dw, w |
| hour | hh |
| minute | mi, n |
| second | ss, s |
| millisecond | ms |
| microsecond | mcs |
startdate
Is an expression that can be resolved to a datetime. date can be an expression, column expression, or string literal. Startdate is substructed from enddate
enddate
Is an expression that can be resolved to a datetime. date can be an expression, column expression, or string literal. Startdate is substructed from enddate
Return Types
bigint
Examples
SELECT DATEDIFF (minute, EntryTime, CAST('2014-09-10 12:00:00' AS datetime)) AS DiffTime
FROM Input TIMESTAMP BY EntryTime
WHERE Toll > 5
SELECT DATEDIFF (minute, EntryTime, DATEADD(hour,2,EntryTime)) AS DiffTime
FROM Input TIMESTAMP BY EntryTime
WHERE Toll > 5
Note
In Stream Analytics Query Language there is a special use of DATEDIFF function when used inside a JOIN condition. See JOIN (Azure Stream Analytics).