yql/essentials/tests/sql/suites/blocks/interval_sub_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;