This function returns the duration between two dates b and a in time unit c.
Parameters
Parameter | Description |
|---|---|
a | Date. |
b | Date. |
c | Unit (y, M, d, h, m, s, S). |
Possible units for parameter c
Value | Time unit |
|---|---|
milli or S | Milliseconds. |
sec or s | Seconds. |
min or m | Minutes. |
hour or H | Hours. |
day or d | Days. |
month or M | Months. |
year or y | Years. |
Examples
Parameter a | Parameter b | Parameter c | Result |
|---|---|---|---|
2010-03-01 00:00:00 | 2010-03-15 00:00:00 | d | -14 |
2010-03-15 00:00:00 | 2010-03-01 00:00:00 | d | 14 |
2010-03-01 00:00:00 | 2010-03-15 00:00:00 | h | -336 |
2010-03-15 00:00:00 | 2010-03-01 00:00:00 | h | 336 |