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;