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;