1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
insert into table1(ts, tsz, ds) values ('2006-01-01', '2006-06-01', '2007-01-01');
insert into table1(ts, tsz, ds) values ('infinity', 'infinity', now());
insert into table1(ts, tsz, ds) values ('-infinity', '-infinity', now());
insert into table1 (ts, tsz, ds) values (
-- Some nice dates that take place inside the time window that was
-- a tad ambiguous in 2007 in that the definition of daylight savings time
-- was changed - per Bill Moran
insert into table1 (ts, tsz, ds) values (now(), '2007-03-12 11:05:32.913154 edt', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-12 10:05:32.913154 est', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-14 17:39:28.595669 edt', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-14 16:39:28.595669 est', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-28 14:45:55.75936 edt', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-28 13:45:55.75936 est', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-29 13:35:19.960505 edt', now());
insert into table1 (ts, tsz, ds) values (now(), '2007-03-29 12:35:19.960505 est', now());
|
