概述
函数dateAdd()
对一个时间对象进行时间偏移。
参数:dateAdd(<time>, <addedValue>, <unit>)
<time>
:时间对象(datetime、timestamp或string类型)<addedValue>
:偏移量(数值类型)<unit>
:偏移单位(string类型,有效值包括year、month、day、hour、minute和second)
返回值:
- 偏移后的时间(datetime或timestamp类型)
一般用法
本例使用异源别名计算:
uncollect ["2023-04-30 22:00:00", "2023-01-15 22:00:00"] as a
uncollect [2, -30] as b
uncollect ["day", "minute"] as c
return table(a, b, c, dateAdd(a, b, c))
| a | b | c | dateAdd(a, b, c) |
|---------------------|-----|--------|---------------------|
| 2023-04-30 22:00:00 | 2 | day | 2023-05-02 22:00:00 |
| 2023-01-15 22:00:00 | -30 | minute | 2023-01-15 21:30:00 |
本例将异源别名做笛卡尔积组合后计算:
uncollect ["2023-04-30 22:00:00", "2023-01-15 22:00:00"] as a
uncollect [2, -30] as b
uncollect ["day", "minute"] as c
with dateAdd(a, b, c) as d
return table(a, b, c, d)
| a | b | c | d |
|---------------------|-----|--------|---------------------|
| 2023-04-30 22:00:00 | 2 | day | 2023-05-02 22:00:00 |
| 2023-04-30 22:00:00 | 2 | minute | 2023-04-30 22:02:00 |
| 2023-04-30 22:00:00 | -30 | day | 2023-03-31 22:00:00 |
| 2023-04-30 22:00:00 | -30 | minute | 2023-04-30 21:30:00 |
| 2023-01-15 22:00:00 | 2 | day | 2023-01-17 22:00:00 |
| 2023-01-15 22:00:00 | 2 | minute | 2023-01-15 22:02:00 |
| 2023-01-15 22:00:00 | -30 | day | 2022-12-16 22:00:00 |
| 2023-01-15 22:00:00 | -30 | minute | 2023-01-15 21:30:00 |