yql/essentials/tests/sql/suites/blocks/interval_add_interval_scalar.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

USE plato;

SELECT
    ni + Interval("P1D"),
    wi + Interval("P1D"),
    ni + Interval64("P1D"),
    wi + Interval64("P1D")
FROM Dates;

SELECT
    Interval("P1D") + ni,
    Interval("P1D") + wi,
    Interval64("P1D") + ni,
    Interval64("P1D") + wi
FROM Dates;