timetz_tbl.sql 1.2 KB

12345678910111213141516171819202122232425262728293031323334
  1. CREATE TABLE TIMETZ_TBL (f1 time(2) with time zone);
  2. /*
  3. originals:
  4. INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT');
  5. INSERT INTO TIMETZ_TBL VALUES ('01:00 PDT');
  6. INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT');
  7. INSERT INTO TIMETZ_TBL VALUES ('07:07 PST');
  8. INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT');
  9. INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT');
  10. INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT');
  11. INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT');
  12. INSERT INTO TIMETZ_TBL VALUES ('23:59 PDT');
  13. INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT');
  14. INSERT INTO TIMETZ_TBL VALUES ('2003-03-07 15:36:39 America/New_York');
  15. INSERT INTO TIMETZ_TBL VALUES ('2003-07-07 15:36:39 America/New_York');
  16. Restore 'em after timezone got supported in literals
  17. */
  18. INSERT INTO TIMETZ_TBL VALUES ('00:01-07');
  19. INSERT INTO TIMETZ_TBL VALUES ('01:00-07');
  20. INSERT INTO TIMETZ_TBL VALUES ('02:03-07');
  21. INSERT INTO TIMETZ_TBL VALUES ('07:07-08');
  22. INSERT INTO TIMETZ_TBL VALUES ('08:08-04');
  23. INSERT INTO TIMETZ_TBL VALUES ('11:59-07');
  24. INSERT INTO TIMETZ_TBL VALUES ('12:00-07');
  25. INSERT INTO TIMETZ_TBL VALUES ('12:01-07');
  26. INSERT INTO TIMETZ_TBL VALUES ('23:59-07');
  27. INSERT INTO TIMETZ_TBL VALUES ('23:59:59.99-07');
  28. INSERT INTO TIMETZ_TBL VALUES ('15:36:39-05');
  29. INSERT INTO TIMETZ_TBL VALUES ('15:36:39-04');