Description
Calculates the difference between two dates in a specified unit of measurement
Syntax
DATEDIFF(<units>, <date1>, <date2> [roundingmode])
Arguments
| Argument |
Type |
Description |
Optional |
| units |
DateInterval (see definition below) |
Units of measurement to use for the return value |
No |
| date1 |
DateTime |
DateTime value subtracted from date2 |
No |
| date2 |
DateTime |
DateTime value from which date1 is subtracted |
No |
| roundingmode |
RoundingMode (see definition below) |
Determines whether the result is rounded or truncated |
Yes |
DateInterval
| Value |
Description |
| 0 |
Year |
| 2 |
Month |
| 4 |
Day |
| 7 |
Hour |
| 8 |
Minute |
| 9 |
Second |
RoundingMode
| Value |
Description |
| 0 |
Round (Default) |
| 1 |
Truncate |
| 2 |
Exact |
Returns
Whole Number (if Round or Truncate used) or Decimal (if Exact used)
Examples
| Expression: |
DATEDIFF(0, "2013-1-1","2014-12-1", 0) |
| Returns: |
2 |
| Expression: |
DATEDIFF(0, "2013-1-1","2014-12-1", 1) |
| Returns: |
1 |
| Expression: |
DATEDIFF(0, "2013-1-1","2014-12-1", 2) |
| Returns: |
1.91446094033416 |
| Expression: |
DATEDIFF(8, "2014-1-1 10:00","2014-1-1 11:30", 2) |
| Returns: |
90 |
Download
Download Example
