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