Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 686cf76645
Branches Tags
ydb
/
yql
/
essentials
/
tests
/
sql
/
suites
/
datetime
/
date_tz_bounds_scale.sql

date_tz_bounds_scale.sql 1.8 KB
History Raw

12345678910111213141516171819202122232425262728293031 
  1. /* postgres can not */
    2. 

  2. select 
    3. 

  3.     cast(TZDATE("1970-01-02,Europe/Moscow") as TzDatetime),
    4. 

  4.     cast(TZDATE("1970-01-01,America/Los_Angeles") as TzDatetime),
    5. 

  5.     cast(TZDATE("2105-12-31,Europe/Moscow") as TzDatetime),
    6. 

  6.     cast(TZDATE("2105-12-31,America/Los_Angeles") as TzDatetime),
    7. 

  7. 

  8.     cast(TZDATE("1970-01-02,Europe/Moscow") as TzTimestamp),
    9. 

  9.     cast(TZDATE("1970-01-01,America/Los_Angeles") as TzTimestamp),
    10. 

  10.     cast(TZDATE("2105-12-31,Europe/Moscow") as TzTimestamp),
    11. 

  11.     cast(TZDATE("2105-12-31,America/Los_Angeles") as TzTimestamp),
    12. 

  12. 

  13.     cast(TZDATETIME("1970-01-02T00:00:00,Europe/Moscow") as TzDate),
    14. 

  14.     cast(TZDATETIME("1970-01-01T00:00:00,America/Los_Angeles") as TzDate),
    15. 

  15.     cast(TZDATETIME("2106-01-01T02:59:59,Europe/Moscow") as TzDate),
    16. 

  16.     cast(TZDATETIME("2105-12-31T15:59:59,America/Los_Angeles") as TzDate),
    17. 

  17. 

  18.     cast(TZDATETIME("1970-01-02T00:00:00,Europe/Moscow") as TzTimestamp),
    19. 

  19.     cast(TZDATETIME("1970-01-01T00:00:00,America/Los_Angeles") as TzTimestamp),
    20. 

  20.     cast(TZDATETIME("2106-01-01T02:59:59,Europe/Moscow") as TzTimestamp),
    21. 

  21.     cast(TZDATETIME("2105-12-31T15:59:59,America/Los_Angeles") as TzTimestamp),
    22. 

  22. 

  23.     cast(TZTIMESTAMP("1970-01-02T00:00:00.000000,Europe/Moscow") as TzDate),
    24. 

  24.     cast(TZTIMESTAMP("1970-01-01T00:00:00.000000,America/Los_Angeles") as TzDate),
    25. 

  25.     cast(TZTIMESTAMP("2106-01-01T02:59:59.999999,Europe/Moscow") as TzDate),
    26. 

  26.     cast(TZTIMESTAMP("2105-12-31T15:59:59.999999,America/Los_Angeles") as TzDate),
    27. 

  27. 

  28.     cast(TZTIMESTAMP("1970-01-02T00:00:00.000000,Europe/Moscow") as TzDatetime),
    29. 

  29.     cast(TZTIMESTAMP("1970-01-01T00:00:00.000000,America/Los_Angeles") as TzDatetime),
    30. 

  30.     cast(TZTIMESTAMP("2106-01-01T02:59:59.999999,Europe/Moscow") as TzDatetime),
    31. 

  31.     cast(TZTIMESTAMP("2105-12-31T15:59:59.999999,America/Los_Angeles") as TzDatetime)
    32.