ydb/yt/yql/tests/sql/suites/blocks/date_sub_interval_scalar.sql

USE plato;
pragma yt.DisableOptimizers="OutHorizontalJoin,HorizontalJoin,MultiHorizontalJoin,FuseMultiOutsWithOuterMaps";

SELECT
    Date("2000-01-01") - ni,
    Date("2000-01-01") - wi,
    TzDate("2000-01-01,Europe/Moscow") - ni,
    TzDate("2000-01-01,Europe/Moscow") - wi,
    Datetime("2000-01-01T03:04:05Z") - ni,
    Datetime("2000-01-01T03:04:05Z") - wi,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - ni,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - wi,
    Timestamp("2000-01-01T03:04:05.678912Z") - ni,
    Timestamp("2000-01-01T03:04:05.678912Z") - wi,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - ni,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - wi,
    Date32("1900-01-01") - ni,
    Date32("1900-01-01") - wi,
    Datetime64("1900-01-01T03:04:05Z") - ni,
    Datetime64("1900-01-01T03:04:05Z") - wi,
    Timestamp64("1900-01-01T03:04:05.678912Z") - ni,
    Timestamp64("1900-01-01T03:04:05.678912Z") - wi,
    TzDate32("1900-01-01,Europe/Moscow") - ni,
    TzDate32("1900-01-01,Europe/Moscow") - wi,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - ni,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - wi,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - ni,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - wi
FROM Dates;

SELECT
    na - Interval("P1D"),
    na - Interval64("P1D"),
    naz - Interval("P1D"),
    naz - Interval64("P1D"),
    nd - Interval("P1D"),
    nd - Interval64("P1D"),
    ndz - Interval("P1D"),
    ndz - Interval64("P1D"),
    nt - Interval("P1D"),
    nt - Interval64("P1D"),
    ntz - Interval("P1D"),
    ntz - Interval64("P1D"),
    wa - Interval("P1D"),
    wa - Interval64("P1D"),
    wd - Interval("P1D"),
    wd - Interval64("P1D"),
    wt - Interval("P1D"),
    wt - Interval64("P1D"),
    waz - Interval("P1D"),
    waz - Interval64("P1D"),
    wdz - Interval("P1D"),
    wdz - Interval64("P1D"),
    wtz - Interval("P1D"),
    wtz - Interval64("P1D")
FROM Dates;