SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git


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

SELECT
    Date("2000-01-01") - na,
    Date("2000-01-01") - naz,
    Date("2000-01-01") - nd,
    Date("2000-01-01") - ndz,
    Date("2000-01-01") - nt,
    Date("2000-01-01") - ntz,
    Date("2000-01-01") - wa,
    Date("2000-01-01") - wd,
    Date("2000-01-01") - wt,
    Date("2000-01-01") - waz,
    Date("2000-01-01") - wdz,
    Date("2000-01-01") - wtz,

    TzDate("2000-01-01,Europe/Moscow") - na,
    TzDate("2000-01-01,Europe/Moscow") - naz,
    TzDate("2000-01-01,Europe/Moscow") - nd,
    TzDate("2000-01-01,Europe/Moscow") - ndz,
    TzDate("2000-01-01,Europe/Moscow") - nt,
    TzDate("2000-01-01,Europe/Moscow") - ntz,
    TzDate("2000-01-01,Europe/Moscow") - wa,
    TzDate("2000-01-01,Europe/Moscow") - wd,
    TzDate("2000-01-01,Europe/Moscow") - wt,
    TzDate("2000-01-01,Europe/Moscow") - waz,
    TzDate("2000-01-01,Europe/Moscow") - wdz,
    TzDate("2000-01-01,Europe/Moscow") - wtz,

    Datetime("2000-01-01T03:04:05Z") - na,
    Datetime("2000-01-01T03:04:05Z") - naz,
    Datetime("2000-01-01T03:04:05Z") - nd,
    Datetime("2000-01-01T03:04:05Z") - ndz,
    Datetime("2000-01-01T03:04:05Z") - nt,
    Datetime("2000-01-01T03:04:05Z") - ntz,
    Datetime("2000-01-01T03:04:05Z") - wa,
    Datetime("2000-01-01T03:04:05Z") - wd,
    Datetime("2000-01-01T03:04:05Z") - wt,
    Datetime("2000-01-01T03:04:05Z") - waz,
    Datetime("2000-01-01T03:04:05Z") - wdz,
    Datetime("2000-01-01T03:04:05Z") - wtz,

    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - na,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - naz,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - nd,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - ndz,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - nt,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - ntz,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - wa,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - wd,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - wt,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - waz,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - wdz,
    TzDatetime("2000-01-01T03:04:05,Europe/Moscow") - wtz,

    Timestamp("2000-01-01T03:04:05.678912Z") - na,
    Timestamp("2000-01-01T03:04:05.678912Z") - naz,
    Timestamp("2000-01-01T03:04:05.678912Z") - nd,
    Timestamp("2000-01-01T03:04:05.678912Z") - ndz,
    Timestamp("2000-01-01T03:04:05.678912Z") - nt,
    Timestamp("2000-01-01T03:04:05.678912Z") - ntz,
    Timestamp("2000-01-01T03:04:05.678912Z") - wa,
    Timestamp("2000-01-01T03:04:05.678912Z") - wd,
    Timestamp("2000-01-01T03:04:05.678912Z") - wt,
    Timestamp("2000-01-01T03:04:05.678912Z") - waz,
    Timestamp("2000-01-01T03:04:05.678912Z") - wdz,
    Timestamp("2000-01-01T03:04:05.678912Z") - wtz,

    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - na,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - naz,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - nd,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - ndz,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - nt,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - ntz,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - wa,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - wd,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - wt,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - waz,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - wdz,
    TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") - wtz,

FROM Dates;

SELECT
    Date32("1900-01-01") - na,
    Date32("1900-01-01") - naz,
    Date32("1900-01-01") - nd,
    Date32("1900-01-01") - ndz,
    Date32("1900-01-01") - nt,
    Date32("1900-01-01") - ntz,
    Date32("1900-01-01") - wa,
    Date32("1900-01-01") - wd,
    Date32("1900-01-01") - wt,
    Date32("1900-01-01") - waz,
    Date32("1900-01-01") - wdz,
    Date32("1900-01-01") - wtz,

    Datetime64("1900-01-01T03:04:05Z") - na,
    Datetime64("1900-01-01T03:04:05Z") - naz,
    Datetime64("1900-01-01T03:04:05Z") - nd,
    Datetime64("1900-01-01T03:04:05Z") - ndz,
    Datetime64("1900-01-01T03:04:05Z") - nt,
    Datetime64("1900-01-01T03:04:05Z") - ntz,
    Datetime64("1900-01-01T03:04:05Z") - wa,
    Datetime64("1900-01-01T03:04:05Z") - wd,
    Datetime64("1900-01-01T03:04:05Z") - wt,
    Datetime64("1900-01-01T03:04:05Z") - waz,
    Datetime64("1900-01-01T03:04:05Z") - wdz,
    Datetime64("1900-01-01T03:04:05Z") - wtz,

    Timestamp64("1900-01-01T03:04:05.678912Z") - na,
    Timestamp64("1900-01-01T03:04:05.678912Z") - naz,
    Timestamp64("1900-01-01T03:04:05.678912Z") - nd,
    Timestamp64("1900-01-01T03:04:05.678912Z") - ndz,
    Timestamp64("1900-01-01T03:04:05.678912Z") - nt,
    Timestamp64("1900-01-01T03:04:05.678912Z") - ntz,
    Timestamp64("1900-01-01T03:04:05.678912Z") - wa,
    Timestamp64("1900-01-01T03:04:05.678912Z") - wd,
    Timestamp64("1900-01-01T03:04:05.678912Z") - wt,
    Timestamp64("1900-01-01T03:04:05.678912Z") - waz,
    Timestamp64("1900-01-01T03:04:05.678912Z") - wdz,
    Timestamp64("1900-01-01T03:04:05.678912Z") - wtz,

    TzDate32("1900-01-01,Europe/Moscow") - na,
    TzDate32("1900-01-01,Europe/Moscow") - naz,
    TzDate32("1900-01-01,Europe/Moscow") - nd,
    TzDate32("1900-01-01,Europe/Moscow") - ndz,
    TzDate32("1900-01-01,Europe/Moscow") - nt,
    TzDate32("1900-01-01,Europe/Moscow") - ntz,
    TzDate32("1900-01-01,Europe/Moscow") - wa,
    TzDate32("1900-01-01,Europe/Moscow") - wd,
    TzDate32("1900-01-01,Europe/Moscow") - wt,
    TzDate32("1900-01-01,Europe/Moscow") - waz,
    TzDate32("1900-01-01,Europe/Moscow") - wdz,
    TzDate32("1900-01-01,Europe/Moscow") - wtz,

    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - na,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - naz,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - nd,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - ndz,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - nt,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - ntz,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - wa,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - wd,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - wt,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - waz,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - wdz,
    TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") - wtz,

    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - na,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - naz,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - nd,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - ndz,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - nt,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - ntz,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - wa,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - wd,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - wt,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - waz,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - wdz,
    TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") - wtz

FROM Dates;

SELECT
    na - Date("2000-01-01"),
    naz - Date("2000-01-01"),
    nd - Date("2000-01-01"),
    ndz - Date("2000-01-01"),
    nt - Date("2000-01-01"),
    ntz - Date("2000-01-01"),
    wa - Date("2000-01-01"),
    wd - Date("2000-01-01"),
    wt - Date("2000-01-01"),
    waz - Date("2000-01-01"),
    wdz - Date("2000-01-01"),
    wtz - Date("2000-01-01"),

    na - TzDate("2000-01-01,Europe/Moscow"),
    naz - TzDate("2000-01-01,Europe/Moscow"),
    nd - TzDate("2000-01-01,Europe/Moscow"),
    ndz - TzDate("2000-01-01,Europe/Moscow"),
    nt - TzDate("2000-01-01,Europe/Moscow"),
    ntz - TzDate("2000-01-01,Europe/Moscow"),
    wa - TzDate("2000-01-01,Europe/Moscow"),
    wd - TzDate("2000-01-01,Europe/Moscow"),
    wt - TzDate("2000-01-01,Europe/Moscow"),
    waz - TzDate("2000-01-01,Europe/Moscow"),
    wdz - TzDate("2000-01-01,Europe/Moscow"),
    wtz - TzDate("2000-01-01,Europe/Moscow"),

    na - Datetime("2000-01-01T03:04:05Z"),
    naz - Datetime("2000-01-01T03:04:05Z"),
    nd - Datetime("2000-01-01T03:04:05Z"),
    ndz - Datetime("2000-01-01T03:04:05Z"),
    nt - Datetime("2000-01-01T03:04:05Z"),
    ntz - Datetime("2000-01-01T03:04:05Z"),
    wa - Datetime("2000-01-01T03:04:05Z"),
    wd - Datetime("2000-01-01T03:04:05Z"),
    wt - Datetime("2000-01-01T03:04:05Z"),
    waz - Datetime("2000-01-01T03:04:05Z"),
    wdz - Datetime("2000-01-01T03:04:05Z"),
    wtz - Datetime("2000-01-01T03:04:05Z"),

    na - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    naz - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    nd - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    ndz - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    nt - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    ntz - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    wa - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    wd - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    wt - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    waz - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    wdz - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
    wtz - TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),

    na - Timestamp("2000-01-01T03:04:05.678912Z"),
    naz - Timestamp("2000-01-01T03:04:05.678912Z"),
    nd - Timestamp("2000-01-01T03:04:05.678912Z"),
    ndz - Timestamp("2000-01-01T03:04:05.678912Z"),
    nt - Timestamp("2000-01-01T03:04:05.678912Z"),
    ntz - Timestamp("2000-01-01T03:04:05.678912Z"),
    wa - Timestamp("2000-01-01T03:04:05.678912Z"),
    wd - Timestamp("2000-01-01T03:04:05.678912Z"),
    wt - Timestamp("2000-01-01T03:04:05.678912Z"),
    waz - Timestamp("2000-01-01T03:04:05.678912Z"),
    wdz - Timestamp("2000-01-01T03:04:05.678912Z"),
    wtz - Timestamp("2000-01-01T03:04:05.678912Z"),

    na - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    naz - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    nd - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    ndz - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    nt - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    ntz - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    wa - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    wd - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    wt - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    waz - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    wdz - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
    wtz - TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
FROM Dates;

SELECT
    na - Date32("1900-01-01"),
    naz - Date32("1900-01-01"),
    nd - Date32("1900-01-01"),
    ndz - Date32("1900-01-01"),
    nt - Date32("1900-01-01"),
    ntz - Date32("1900-01-01"),
    wa - Date32("1900-01-01"),
    wd - Date32("1900-01-01"),
    wt - Date32("1900-01-01"),
    waz - Date32("1900-01-01"),
    wdz - Date32("1900-01-01"),
    wtz - Date32("1900-01-01"),

    na - Datetime64("1900-01-01T03:04:05Z"),
    naz - Datetime64("1900-01-01T03:04:05Z"),
    nd - Datetime64("1900-01-01T03:04:05Z"),
    ndz - Datetime64("1900-01-01T03:04:05Z"),
    nt - Datetime64("1900-01-01T03:04:05Z"),
    ntz - Datetime64("1900-01-01T03:04:05Z"),
    wa - Datetime64("1900-01-01T03:04:05Z"),
    wd - Datetime64("1900-01-01T03:04:05Z"),
    wt - Datetime64("1900-01-01T03:04:05Z"),
    waz - Datetime64("1900-01-01T03:04:05Z"),
    wdz - Datetime64("1900-01-01T03:04:05Z"),
    wtz - Datetime64("1900-01-01T03:04:05Z"),

    na - Timestamp64("1900-01-01T03:04:05.678912Z"),
    naz - Timestamp64("1900-01-01T03:04:05.678912Z"),
    nd - Timestamp64("1900-01-01T03:04:05.678912Z"),
    ndz - Timestamp64("1900-01-01T03:04:05.678912Z"),
    nt - Timestamp64("1900-01-01T03:04:05.678912Z"),
    ntz - Timestamp64("1900-01-01T03:04:05.678912Z"),
    wa - Timestamp64("1900-01-01T03:04:05.678912Z"),
    wd - Timestamp64("1900-01-01T03:04:05.678912Z"),
    wt - Timestamp64("1900-01-01T03:04:05.678912Z"),
    waz - Timestamp64("1900-01-01T03:04:05.678912Z"),
    wdz - Timestamp64("1900-01-01T03:04:05.678912Z"),
    wtz - Timestamp64("1900-01-01T03:04:05.678912Z"),

    na - TzDate32("1900-01-01,Europe/Moscow"),
    naz - TzDate32("1900-01-01,Europe/Moscow"),
    nd - TzDate32("1900-01-01,Europe/Moscow"),
    ndz - TzDate32("1900-01-01,Europe/Moscow"),
    nt - TzDate32("1900-01-01,Europe/Moscow"),
    ntz - TzDate32("1900-01-01,Europe/Moscow"),
    wa - TzDate32("1900-01-01,Europe/Moscow"),
    wd - TzDate32("1900-01-01,Europe/Moscow"),
    wt - TzDate32("1900-01-01,Europe/Moscow"),
    waz - TzDate32("1900-01-01,Europe/Moscow"),
    wdz - TzDate32("1900-01-01,Europe/Moscow"),
    wtz - TzDate32("1900-01-01,Europe/Moscow"),

    na - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    naz - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    nd - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    ndz - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    nt - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    ntz - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    wa - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    wd - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    wt - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    waz - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    wdz - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
    wtz - TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),

    na - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    naz - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    nd - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    ndz - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    nt - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    ntz - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    wa - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    wd - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    wt - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    waz - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    wdz - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
    wtz - TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow")

FROM Dates;