Interval

INTERVAL

INTERVAL consists of multiple date parts and represents the total time length of these date parts. Kùzu follows DuckDB’s implementation for the format of specifying intervals.

INTERVAL creation

RETURN interval("1 year 2 days") as x;

Output:

-----------------
| x             |
-----------------
| 1 year 2 days |
-----------------