函数 dateDiff() 可以计算两个时间类型的时间差(终点减去起点),并返回这个时长(取整数部分)。
Arguments:
- 时间终点 <datetime | timestamp | string>
- 时间起点 <datetime | timestamp | string>
- 差值单位 <string>,有效值:day, hour, minute, second
Returns:
- 时间差 <number>
一般用法
示例:异源别名直接计算
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 |