interval_sub_interval.sql « blocks « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/blocks/interval_sub_interval.sql

blob: eaf0809d0bc62707ae76d9814d7024b832025bfb (plain) (blame)

USE plato;

SELECT
    a.ni - b.ni,
    a.ni - b.wi,
    a.wi - b.ni,
    a.wi - b.wi
FROM Dates as a CROSS JOIN Dates as b