概述
函数dateDiff()
计算两个时间对象的时差。
参数:dateDiff(<time_1>, <time_2>, <unit>)
<time_1>
和<time_2>
:两个时间对象(datetime、timestamp或string类型)<unit>
:时差单位(string类型,有效值包括day、hour、minute和second)
返回值:
- 计算后的时差(数值类型)
- 计算方法:
<time_2>
-<time_1>
- 返回的时差仅保留整数部分
一般用法
本例使用异源别名计算:
uncollect ["2023-04-30 22:00:00", "2023-01-15 22:00:00"] as a
uncollect ["2023-04-28 22:00:00", "2023-01-15 23:00:00"] as b
uncollect ["day", "minute"] as c
return table(a, b, c, dateDiff(a, b, c))
| a | b | c | dateDiff(a, b, c) |
|---------------------|---------------------|--------|-------------------|
| 2023-04-30 22:00:00 | 2023-04-28 22:00:00 | day | 2 |
| 2023-01-15 22:00:00 | 2023-01-15 23:00:00 | minute | -60 |
本例将异源别名做笛卡尔积组合后计算:
uncollect ["2023-04-30 22:00:00", "2023-01-15 22:00:00"] as a
uncollect ["2023-04-28 22:00:00", "2023-01-15 23:00:00"] as b
uncollect ["day", "minute"] as c
with dateDiff(a, b, c) as d
return table(a, b, c, d)
| a | b | c | d |
|---------------------|---------------------|--------|---------|
| 2023-04-30 22:00:00 | 2023-04-28 22:00:00 | day | 2 |
| 2023-04-30 22:00:00 | 2023-04-28 22:00:00 | minute | 2880 |
| 2023-04-30 22:00:00 | 2023-01-15 23:00:00 | day | 104 |
| 2023-04-30 22:00:00 | 2023-01-15 23:00:00 | minute | 151140 |
| 2023-01-15 22:00:00 | 2023-04-28 22:00:00 | day | -103 |
| 2023-01-15 22:00:00 | 2023-04-28 22:00:00 | minute | -148320 |
| 2023-01-15 22:00:00 | 2023-01-15 23:00:00 | day | 0 |
| 2023-01-15 22:00:00 | 2023-01-15 23:00:00 | minute | -60 |