date_tz_bounds.sql 685 B

1234567891011121314151617
  1. /* postgres can not */
  2. select
  3. TZDATE("1970-01-02,Europe/Moscow"),
  4. TZDATE("1970-01-01,America/Los_Angeles"),
  5. TZDATE("2105-12-31,Europe/Moscow"),
  6. TZDATE("2105-12-31,America/Los_Angeles"),
  7. TZDATETIME("1970-01-01T03:00:00,Europe/Moscow"),
  8. TZDATETIME("1969-12-31T16:00:00,America/Los_Angeles"),
  9. TZDATETIME("2106-01-01T02:59:59,Europe/Moscow"),
  10. TZDATETIME("2105-12-31T15:59:59,America/Los_Angeles"),
  11. TZTIMESTAMP("1970-01-01T03:00:00.000000,Europe/Moscow"),
  12. TZTIMESTAMP("1969-12-31T16:00:00.000000,America/Los_Angeles"),
  13. TZTIMESTAMP("2106-01-01T02:59:59.999999,Europe/Moscow"),
  14. TZTIMESTAMP("2105-12-31T15:59:59.999999,America/Los_Angeles")