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 |