Date operators
Kùzu supports the following operators to work with date and interval values:
| Operator | Description | Example | Result |
|---|---|---|---|
| + | addition of INT64 | DATE('2022-11-12') + 5 | 2022-11-17 (DATE) |
| + | addition of INTERVAL | DATE('2021-10-12') + INTERVAL(3 DAYS) | 2021-10-15 |
| - | subtraction of INT64 | DATE('2022-11-12') - DATE(2022-11-11) | 1 |
| - | subtraction of INTERVAL | DATE('2023-10-11') - INTERVAL(10 DAYS) | 2023-10-01 |