5 -- date, time arithmetic
7 SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time";
9 ------------------------------
10 Tue Feb 03 04:05:06 1981 PST
13 SELECT date '1991-02-03' + time with time zone '04:05:06 PST' AS "Date + Time PST";
15 ------------------------------
16 Sun Feb 03 04:05:06 1991 PST
19 SELECT date '2001-02-03' + time with time zone '04:05:06 UTC' AS "Date + Time UTC";
21 ------------------------------
22 Fri Feb 02 20:05:06 2001 PST
25 SELECT date '1991-02-03' + interval '2 years' AS "Add Two Years";
27 ------------------------------
28 Wed Feb 03 00:00:00 1993 PST
31 SELECT date '2001-12-13' - interval '2 years' AS "Subtract Two Years";
33 ------------------------------
34 Mon Dec 13 00:00:00 1999 PST
37 SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";
39 ------------------------------
40 Sat Feb 02 19:54:54 1991 PST
43 SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";
44 ERROR: Unable to identify an operator '-' for types 'date' and 'timetz'
45 You will have to retype this query using an explicit cast
47 -- timestamp, interval arithmetic
49 SELECT timestamp '1996-03-01' - interval '1 second' AS "Feb 29";
51 ------------------------------
52 Thu Feb 29 23:59:59 1996 PST
55 SELECT timestamp '1999-03-01' - interval '1 second' AS "Feb 28";
57 ------------------------------
58 Sun Feb 28 23:59:59 1999 PST
61 SELECT timestamp '2000-03-01' - interval '1 second' AS "Feb 29";
63 ------------------------------
64 Tue Feb 29 23:59:59 2000 PST
67 SELECT timestamp '1999-12-01' + interval '1 month - 1 second' AS "Dec 31";
69 ------------------------------
70 Fri Dec 31 23:59:59 1999 PST
74 -- time, interval arithmetic
76 SELECT CAST(time '01:02' AS interval) AS "+01:02";
82 SELECT CAST(interval '02:03' AS time) AS "02:03:00";
88 SELECT time '01:30' + interval '02:01' AS "03:31:00";
94 SELECT time '01:30' - interval '02:01' AS "23:29:00";
100 SELECT time '02:30' + interval '36:01' AS "14:31:00";
106 SELECT time '03:30' + interval '1 month 04:01' AS "07:31:00";
112 SELECT interval '04:30' - time '01:02' AS "+03:28";
118 SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01";
119 ERROR: Cannot cast type 'timetz' to 'interval'
120 SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08";
121 ERROR: Cannot cast type 'interval' to 'timetz'
122 SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";
128 SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08";
134 -- These two tests cannot be used because they default to current timezone,
135 -- which may be either -08 or -07 depending on the time of year.
136 -- SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";
137 -- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08";
138 -- Try the following two tests instead, as a poor substitute
139 SELECT CAST(date 'today' + time with time zone '01:30'
140 + interval '02:01' AS time) AS "03:31:00";
146 SELECT CAST(date 'today' + time with time zone '03:30'
147 + interval '1 month 04:01' AS time) AS "07:31:00";
153 SELECT interval '04:30' - time with time zone '01:02' AS "+03:28";
154 ERROR: Unable to identify an operator '-' for types 'interval' and 'timetz'
155 You will have to retype this query using an explicit cast
156 -- We get 100 rows when run in GMT...
157 SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
158 WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
159 AND i.f1 BETWEEN '00:00' AND '23:00';
161 ---------------------------------
162 Mon Feb 10 17:33:01 1997 PST
163 Mon Feb 10 22:32:01 1997 PST
164 Mon Feb 10 17:33:01.00 1997 PST
165 Mon Feb 10 22:32:01.00 1997 PST
166 Mon Feb 10 17:33:02.00 1997 PST
167 Mon Feb 10 22:32:02.00 1997 PST
168 Mon Feb 10 17:33:01.40 1997 PST
169 Mon Feb 10 22:32:01.40 1997 PST
170 Mon Feb 10 17:33:01.50 1997 PST
171 Mon Feb 10 22:32:01.50 1997 PST
172 Mon Feb 10 17:33:01.60 1997 PST
173 Mon Feb 10 22:32:01.60 1997 PST
174 Thu Jan 02 00:01:00 1997 PST
175 Thu Jan 02 05:00:00 1997 PST
176 Thu Jan 02 03:05:05 1997 PST
177 Thu Jan 02 08:04:05 1997 PST
178 Mon Feb 10 17:33:01 1997 PST
179 Mon Feb 10 22:32:01 1997 PST
180 Mon Feb 10 17:33:01 1997 PST
181 Mon Feb 10 22:32:01 1997 PST
182 Mon Feb 10 17:33:01 1997 PST
183 Mon Feb 10 22:32:01 1997 PST
184 Mon Feb 10 17:33:01 1997 PST
185 Mon Feb 10 22:32:01 1997 PST
186 Tue Jun 10 17:33:01 1997 PDT
187 Tue Jun 10 22:32:01 1997 PDT
188 Wed Mar 15 08:15:01 2000 PST
189 Wed Mar 15 13:14:01 2000 PST
190 Wed Mar 15 04:15:02 2000 PST
191 Wed Mar 15 09:14:02 2000 PST
192 Wed Mar 15 02:15:03 2000 PST
193 Wed Mar 15 07:14:03 2000 PST
194 Wed Mar 15 03:15:04 2000 PST
195 Wed Mar 15 08:14:04 2000 PST
196 Wed Mar 15 01:15:05 2000 PST
197 Wed Mar 15 06:14:05 2000 PST
198 Mon Feb 10 17:33:01 1997 PST
199 Mon Feb 10 22:32:01 1997 PST
200 Mon Feb 10 17:33:01 1997 PST
201 Mon Feb 10 22:32:01 1997 PST
202 Mon Feb 10 17:33:00 1997 PST
203 Mon Feb 10 22:32:00 1997 PST
204 Mon Feb 10 17:33:01 1997 PST
205 Mon Feb 10 22:32:01 1997 PST
206 Mon Feb 10 17:33:01 1997 PST
207 Mon Feb 10 22:32:01 1997 PST
208 Mon Feb 10 17:33:01 1997 PST
209 Mon Feb 10 22:32:01 1997 PST
210 Mon Feb 10 17:33:01 1997 PST
211 Mon Feb 10 22:32:01 1997 PST
212 Mon Feb 10 17:33:01 1997 PST
213 Mon Feb 10 22:32:01 1997 PST
214 Mon Feb 10 09:33:01 1997 PST
215 Mon Feb 10 14:32:01 1997 PST
216 Mon Feb 10 09:33:01 1997 PST
217 Mon Feb 10 14:32:01 1997 PST
218 Mon Feb 10 09:33:01 1997 PST
219 Mon Feb 10 14:32:01 1997 PST
220 Tue Jun 10 18:33:01 1997 PDT
221 Tue Jun 10 23:32:01 1997 PDT
222 Mon Feb 10 17:33:01 1997 PST
223 Mon Feb 10 22:32:01 1997 PST
224 Tue Feb 11 17:33:01 1997 PST
225 Tue Feb 11 22:32:01 1997 PST
226 Wed Feb 12 17:33:01 1997 PST
227 Wed Feb 12 22:32:01 1997 PST
228 Thu Feb 13 17:33:01 1997 PST
229 Thu Feb 13 22:32:01 1997 PST
230 Fri Feb 14 17:33:01 1997 PST
231 Fri Feb 14 22:32:01 1997 PST
232 Sat Feb 15 17:33:01 1997 PST
233 Sat Feb 15 22:32:01 1997 PST
234 Sun Feb 16 17:33:01 1997 PST
235 Sun Feb 16 22:32:01 1997 PST
236 Sun Feb 16 17:33:01 1997 PST
237 Sun Feb 16 22:32:01 1997 PST
238 Wed Feb 28 17:33:01 1996 PST
239 Wed Feb 28 22:32:01 1996 PST
240 Thu Feb 29 17:33:01 1996 PST
241 Thu Feb 29 22:32:01 1996 PST
242 Fri Mar 01 17:33:01 1996 PST
243 Fri Mar 01 22:32:01 1996 PST
244 Mon Dec 30 17:33:01 1996 PST
245 Mon Dec 30 22:32:01 1996 PST
246 Tue Dec 31 17:33:01 1996 PST
247 Tue Dec 31 22:32:01 1996 PST
248 Wed Jan 01 17:33:01 1997 PST
249 Wed Jan 01 22:32:01 1997 PST
250 Fri Feb 28 17:33:01 1997 PST
251 Fri Feb 28 22:32:01 1997 PST
252 Sat Mar 01 17:33:01 1997 PST
253 Sat Mar 01 22:32:01 1997 PST
254 Tue Dec 30 17:33:01 1997 PST
255 Tue Dec 30 22:32:01 1997 PST
256 Wed Dec 31 17:33:01 1997 PST
257 Wed Dec 31 22:32:01 1997 PST
258 Fri Dec 31 17:33:01 1999 PST
259 Fri Dec 31 22:32:01 1999 PST
260 Sat Jan 01 17:33:01 2000 PST
261 Sat Jan 01 22:32:01 2000 PST
262 Sun Dec 31 17:33:01 2000 PST
263 Sun Dec 31 22:32:01 2000 PST
266 SELECT t.d1 - i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
267 WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
268 AND i.f1 BETWEEN '00:00' AND '23:00';
270 ---------------------------------
271 Mon Feb 10 17:31:01 1997 PST
272 Mon Feb 10 12:32:01 1997 PST
273 Mon Feb 10 17:31:01.00 1997 PST
274 Mon Feb 10 12:32:01.00 1997 PST
275 Mon Feb 10 17:31:02.00 1997 PST
276 Mon Feb 10 12:32:02.00 1997 PST
277 Mon Feb 10 17:31:01.40 1997 PST
278 Mon Feb 10 12:32:01.40 1997 PST
279 Mon Feb 10 17:31:01.50 1997 PST
280 Mon Feb 10 12:32:01.50 1997 PST
281 Mon Feb 10 17:31:01.60 1997 PST
282 Mon Feb 10 12:32:01.60 1997 PST
283 Wed Jan 01 23:59:00 1997 PST
284 Wed Jan 01 19:00:00 1997 PST
285 Thu Jan 02 03:03:05 1997 PST
286 Wed Jan 01 22:04:05 1997 PST
287 Mon Feb 10 17:31:01 1997 PST
288 Mon Feb 10 12:32:01 1997 PST
289 Mon Feb 10 17:31:01 1997 PST
290 Mon Feb 10 12:32:01 1997 PST
291 Mon Feb 10 17:31:01 1997 PST
292 Mon Feb 10 12:32:01 1997 PST
293 Mon Feb 10 17:31:01 1997 PST
294 Mon Feb 10 12:32:01 1997 PST
295 Tue Jun 10 17:31:01 1997 PDT
296 Tue Jun 10 12:32:01 1997 PDT
297 Wed Mar 15 08:13:01 2000 PST
298 Wed Mar 15 03:14:01 2000 PST
299 Wed Mar 15 04:13:02 2000 PST
300 Tue Mar 14 23:14:02 2000 PST
301 Wed Mar 15 02:13:03 2000 PST
302 Tue Mar 14 21:14:03 2000 PST
303 Wed Mar 15 03:13:04 2000 PST
304 Tue Mar 14 22:14:04 2000 PST
305 Wed Mar 15 01:13:05 2000 PST
306 Tue Mar 14 20:14:05 2000 PST
307 Mon Feb 10 17:31:01 1997 PST
308 Mon Feb 10 12:32:01 1997 PST
309 Mon Feb 10 17:31:01 1997 PST
310 Mon Feb 10 12:32:01 1997 PST
311 Mon Feb 10 17:31:00 1997 PST
312 Mon Feb 10 12:32:00 1997 PST
313 Mon Feb 10 17:31:01 1997 PST
314 Mon Feb 10 12:32:01 1997 PST
315 Mon Feb 10 17:31:01 1997 PST
316 Mon Feb 10 12:32:01 1997 PST
317 Mon Feb 10 17:31:01 1997 PST
318 Mon Feb 10 12:32:01 1997 PST
319 Mon Feb 10 17:31:01 1997 PST
320 Mon Feb 10 12:32:01 1997 PST
321 Mon Feb 10 17:31:01 1997 PST
322 Mon Feb 10 12:32:01 1997 PST
323 Mon Feb 10 09:31:01 1997 PST
324 Mon Feb 10 04:32:01 1997 PST
325 Mon Feb 10 09:31:01 1997 PST
326 Mon Feb 10 04:32:01 1997 PST
327 Mon Feb 10 09:31:01 1997 PST
328 Mon Feb 10 04:32:01 1997 PST
329 Tue Jun 10 18:31:01 1997 PDT
330 Tue Jun 10 13:32:01 1997 PDT
331 Mon Feb 10 17:31:01 1997 PST
332 Mon Feb 10 12:32:01 1997 PST
333 Tue Feb 11 17:31:01 1997 PST
334 Tue Feb 11 12:32:01 1997 PST
335 Wed Feb 12 17:31:01 1997 PST
336 Wed Feb 12 12:32:01 1997 PST
337 Thu Feb 13 17:31:01 1997 PST
338 Thu Feb 13 12:32:01 1997 PST
339 Fri Feb 14 17:31:01 1997 PST
340 Fri Feb 14 12:32:01 1997 PST
341 Sat Feb 15 17:31:01 1997 PST
342 Sat Feb 15 12:32:01 1997 PST
343 Sun Feb 16 17:31:01 1997 PST
344 Sun Feb 16 12:32:01 1997 PST
345 Sun Feb 16 17:31:01 1997 PST
346 Sun Feb 16 12:32:01 1997 PST
347 Wed Feb 28 17:31:01 1996 PST
348 Wed Feb 28 12:32:01 1996 PST
349 Thu Feb 29 17:31:01 1996 PST
350 Thu Feb 29 12:32:01 1996 PST
351 Fri Mar 01 17:31:01 1996 PST
352 Fri Mar 01 12:32:01 1996 PST
353 Mon Dec 30 17:31:01 1996 PST
354 Mon Dec 30 12:32:01 1996 PST
355 Tue Dec 31 17:31:01 1996 PST
356 Tue Dec 31 12:32:01 1996 PST
357 Wed Jan 01 17:31:01 1997 PST
358 Wed Jan 01 12:32:01 1997 PST
359 Fri Feb 28 17:31:01 1997 PST
360 Fri Feb 28 12:32:01 1997 PST
361 Sat Mar 01 17:31:01 1997 PST
362 Sat Mar 01 12:32:01 1997 PST
363 Tue Dec 30 17:31:01 1997 PST
364 Tue Dec 30 12:32:01 1997 PST
365 Wed Dec 31 17:31:01 1997 PST
366 Wed Dec 31 12:32:01 1997 PST
367 Fri Dec 31 17:31:01 1999 PST
368 Fri Dec 31 12:32:01 1999 PST
369 Sat Jan 01 17:31:01 2000 PST
370 Sat Jan 01 12:32:01 2000 PST
371 Sun Dec 31 17:31:01 2000 PST
372 Sun Dec 31 12:32:01 2000 PST
375 SELECT t.f1 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
460 SELECT t.f1 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
545 SELECT t.f2 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
630 SELECT t.f2 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
715 -- SQL9x OVERLAPS operator
716 SELECT (timestamp '2000-11-27', timestamp '2000-11-28')
717 OVERLAPS (timestamp '2000-11-27 12:00', timestamp '2000-11-30') AS "True";
723 SELECT (timestamp '2000-11-26', timestamp '2000-11-27')
724 OVERLAPS (timestamp '2000-11-27 12:00', timestamp '2000-11-30') AS "False";
730 SELECT (timestamp '2000-11-27', timestamp '2000-11-28')
731 OVERLAPS (timestamp '2000-11-27 12:00', interval '1 day') AS "True";
737 SELECT (timestamp '2000-11-27', interval '12 hours')
738 OVERLAPS (timestamp '2000-11-27 12:00', timestamp '2000-11-30') AS "False";
744 SELECT (timestamp '2000-11-27', interval '12 hours')
745 OVERLAPS (timestamp '2000-11-27', interval '12 hours') AS "True";
751 SELECT (timestamp '2000-11-27', interval '12 hours')
752 OVERLAPS (timestamp '2000-11-27 12:00', interval '12 hours') AS "False";
758 SELECT (time '00:00', time '01:00')
759 OVERLAPS (time '00:30', time '01:30') AS "True";
765 SELECT (time '00:00', interval '1 hour')
766 OVERLAPS (time '00:30', interval '1 hour') AS "True";
772 SELECT (time '00:00', interval '1 hour')
773 OVERLAPS (time '01:30', interval '1 hour') AS "False";
779 SELECT (time '00:00', interval '1 hour')
780 OVERLAPS (time '01:30', interval '1 day') AS "True";
786 CREATE TABLE TEMP_TIMESTAMP (f1 timestamp);
787 -- get some candidate input values
788 INSERT INTO TEMP_TIMESTAMP (f1)
789 SELECT d1 FROM TIMESTAMP_TBL
790 WHERE d1 BETWEEN '13-jun-1957' AND '1-jan-1997'
791 OR d1 BETWEEN '1-jan-1999' AND '1-jan-2010';
792 SELECT '' AS "15", f1 AS timestamp
796 ----+------------------------------
798 | Wed Feb 28 17:32:01 1996 PST
799 | Thu Feb 29 17:32:01 1996 PST
800 | Fri Mar 01 17:32:01 1996 PST
801 | Mon Dec 30 17:32:01 1996 PST
802 | Tue Dec 31 17:32:01 1996 PST
803 | Fri Dec 31 17:32:01 1999 PST
804 | Sat Jan 01 17:32:01 2000 PST
805 | Wed Mar 15 01:14:05 2000 PST
806 | Wed Mar 15 02:14:03 2000 PST
807 | Wed Mar 15 03:14:04 2000 PST
808 | Wed Mar 15 04:14:02 2000 PST
809 | Wed Mar 15 08:14:01 2000 PST
810 | Sun Dec 31 17:32:01 2000 PST
811 | Mon Jan 01 17:32:01 2001 PST
814 SELECT '' AS "150", d.f1 AS timestamp, t.f1 AS interval, d.f1 + t.f1 AS plus
815 FROM TEMP_TIMESTAMP d, INTERVAL_TBL t
816 ORDER BY plus, timestamp, interval;
817 150 | timestamp | interval | plus
818 -----+------------------------------+-------------------------------+------------------------------
819 | epoch | @ 14 secs ago | Wed Dec 31 15:59:46 1969 PST
820 | epoch | @ 1 min | Wed Dec 31 16:01:00 1969 PST
821 | epoch | @ 5 hours | Wed Dec 31 21:00:00 1969 PST
822 | epoch | @ 1 day 2 hours 3 mins 4 secs | Thu Jan 01 18:03:04 1970 PST
823 | epoch | @ 10 days | Sat Jan 10 16:00:00 1970 PST
824 | epoch | @ 3 mons | Tue Mar 31 16:00:00 1970 PST
825 | epoch | @ 5 mons | Sun May 31 16:00:00 1970 PDT
826 | epoch | @ 5 mons 12 hours | Mon Jun 01 04:00:00 1970 PDT
827 | epoch | @ 6 years | Wed Dec 31 16:00:00 1975 PST
828 | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago | Wed Feb 28 17:31:47 1996 PST
829 | Wed Feb 28 17:32:01 1996 PST | @ 1 min | Wed Feb 28 17:33:01 1996 PST
830 | Wed Feb 28 17:32:01 1996 PST | @ 5 hours | Wed Feb 28 22:32:01 1996 PST
831 | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago | Thu Feb 29 17:31:47 1996 PST
832 | Thu Feb 29 17:32:01 1996 PST | @ 1 min | Thu Feb 29 17:33:01 1996 PST
833 | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 19:35:05 1996 PST
834 | Thu Feb 29 17:32:01 1996 PST | @ 5 hours | Thu Feb 29 22:32:01 1996 PST
835 | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago | Fri Mar 01 17:31:47 1996 PST
836 | Fri Mar 01 17:32:01 1996 PST | @ 1 min | Fri Mar 01 17:33:01 1996 PST
837 | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Mar 01 19:35:05 1996 PST
838 | Fri Mar 01 17:32:01 1996 PST | @ 5 hours | Fri Mar 01 22:32:01 1996 PST
839 | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Mar 02 19:35:05 1996 PST
840 | Wed Feb 28 17:32:01 1996 PST | @ 10 days | Sat Mar 09 17:32:01 1996 PST
841 | Thu Feb 29 17:32:01 1996 PST | @ 10 days | Sun Mar 10 17:32:01 1996 PST
842 | Fri Mar 01 17:32:01 1996 PST | @ 10 days | Mon Mar 11 17:32:01 1996 PST
843 | Wed Feb 28 17:32:01 1996 PST | @ 3 mons | Tue May 28 17:32:01 1996 PDT
844 | Thu Feb 29 17:32:01 1996 PST | @ 3 mons | Wed May 29 17:32:01 1996 PDT
845 | Fri Mar 01 17:32:01 1996 PST | @ 3 mons | Sat Jun 01 17:32:01 1996 PDT
846 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons | Sun Jul 28 17:32:01 1996 PDT
847 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours | Mon Jul 29 05:32:01 1996 PDT
848 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons | Mon Jul 29 17:32:01 1996 PDT
849 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours | Tue Jul 30 05:32:01 1996 PDT
850 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons | Thu Aug 01 17:32:01 1996 PDT
851 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours | Fri Aug 02 05:32:01 1996 PDT
852 | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago | Mon Dec 30 17:31:47 1996 PST
853 | Mon Dec 30 17:32:01 1996 PST | @ 1 min | Mon Dec 30 17:33:01 1996 PST
854 | Mon Dec 30 17:32:01 1996 PST | @ 5 hours | Mon Dec 30 22:32:01 1996 PST
855 | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago | Tue Dec 31 17:31:47 1996 PST
856 | Tue Dec 31 17:32:01 1996 PST | @ 1 min | Tue Dec 31 17:33:01 1996 PST
857 | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 31 19:35:05 1996 PST
858 | Tue Dec 31 17:32:01 1996 PST | @ 5 hours | Tue Dec 31 22:32:01 1996 PST
859 | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Jan 01 19:35:05 1997 PST
860 | Mon Dec 30 17:32:01 1996 PST | @ 10 days | Thu Jan 09 17:32:01 1997 PST
861 | Tue Dec 31 17:32:01 1996 PST | @ 10 days | Fri Jan 10 17:32:01 1997 PST
862 | Mon Dec 30 17:32:01 1996 PST | @ 3 mons | Sun Mar 30 17:32:01 1997 PST
863 | Tue Dec 31 17:32:01 1996 PST | @ 3 mons | Mon Mar 31 17:32:01 1997 PST
864 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons | Fri May 30 17:32:01 1997 PDT
865 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours | Sat May 31 05:32:01 1997 PDT
866 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons | Sat May 31 17:32:01 1997 PDT
867 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours | Sun Jun 01 05:32:01 1997 PDT
868 | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago | Fri Dec 31 17:31:47 1999 PST
869 | Fri Dec 31 17:32:01 1999 PST | @ 1 min | Fri Dec 31 17:33:01 1999 PST
870 | Fri Dec 31 17:32:01 1999 PST | @ 5 hours | Fri Dec 31 22:32:01 1999 PST
871 | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago | Sat Jan 01 17:31:47 2000 PST
872 | Sat Jan 01 17:32:01 2000 PST | @ 1 min | Sat Jan 01 17:33:01 2000 PST
873 | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Jan 01 19:35:05 2000 PST
874 | Sat Jan 01 17:32:01 2000 PST | @ 5 hours | Sat Jan 01 22:32:01 2000 PST
875 | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Jan 02 19:35:05 2000 PST
876 | Fri Dec 31 17:32:01 1999 PST | @ 10 days | Mon Jan 10 17:32:01 2000 PST
877 | Sat Jan 01 17:32:01 2000 PST | @ 10 days | Tue Jan 11 17:32:01 2000 PST
878 | Wed Mar 15 01:14:05 2000 PST | @ 14 secs ago | Wed Mar 15 01:13:51 2000 PST
879 | Wed Mar 15 01:14:05 2000 PST | @ 1 min | Wed Mar 15 01:15:05 2000 PST
880 | Wed Mar 15 02:14:03 2000 PST | @ 14 secs ago | Wed Mar 15 02:13:49 2000 PST
881 | Wed Mar 15 02:14:03 2000 PST | @ 1 min | Wed Mar 15 02:15:03 2000 PST
882 | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago | Wed Mar 15 03:13:50 2000 PST
883 | Wed Mar 15 03:14:04 2000 PST | @ 1 min | Wed Mar 15 03:15:04 2000 PST
884 | Wed Mar 15 04:14:02 2000 PST | @ 14 secs ago | Wed Mar 15 04:13:48 2000 PST
885 | Wed Mar 15 04:14:02 2000 PST | @ 1 min | Wed Mar 15 04:15:02 2000 PST
886 | Wed Mar 15 01:14:05 2000 PST | @ 5 hours | Wed Mar 15 06:14:05 2000 PST
887 | Wed Mar 15 02:14:03 2000 PST | @ 5 hours | Wed Mar 15 07:14:03 2000 PST
888 | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago | Wed Mar 15 08:13:47 2000 PST
889 | Wed Mar 15 03:14:04 2000 PST | @ 5 hours | Wed Mar 15 08:14:04 2000 PST
890 | Wed Mar 15 08:14:01 2000 PST | @ 1 min | Wed Mar 15 08:15:01 2000 PST
891 | Wed Mar 15 04:14:02 2000 PST | @ 5 hours | Wed Mar 15 09:14:02 2000 PST
892 | Wed Mar 15 08:14:01 2000 PST | @ 5 hours | Wed Mar 15 13:14:01 2000 PST
893 | Wed Mar 15 01:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 03:17:09 2000 PST
894 | Wed Mar 15 02:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 04:17:07 2000 PST
895 | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 05:17:08 2000 PST
896 | Wed Mar 15 04:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 06:17:06 2000 PST
897 | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 10:17:05 2000 PST
898 | Wed Mar 15 01:14:05 2000 PST | @ 10 days | Sat Mar 25 01:14:05 2000 PST
899 | Wed Mar 15 02:14:03 2000 PST | @ 10 days | Sat Mar 25 02:14:03 2000 PST
900 | Wed Mar 15 03:14:04 2000 PST | @ 10 days | Sat Mar 25 03:14:04 2000 PST
901 | Wed Mar 15 04:14:02 2000 PST | @ 10 days | Sat Mar 25 04:14:02 2000 PST
902 | Wed Mar 15 08:14:01 2000 PST | @ 10 days | Sat Mar 25 08:14:01 2000 PST
903 | Fri Dec 31 17:32:01 1999 PST | @ 3 mons | Fri Mar 31 17:32:01 2000 PST
904 | Sat Jan 01 17:32:01 2000 PST | @ 3 mons | Sat Apr 01 17:32:01 2000 PST
905 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons | Wed May 31 17:32:01 2000 PDT
906 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours | Thu Jun 01 05:32:01 2000 PDT
907 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons | Thu Jun 01 17:32:01 2000 PDT
908 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours | Fri Jun 02 05:32:01 2000 PDT
909 | Wed Mar 15 01:14:05 2000 PST | @ 3 mons | Thu Jun 15 01:14:05 2000 PDT
910 | Wed Mar 15 02:14:03 2000 PST | @ 3 mons | Thu Jun 15 02:14:03 2000 PDT
911 | Wed Mar 15 03:14:04 2000 PST | @ 3 mons | Thu Jun 15 03:14:04 2000 PDT
912 | Wed Mar 15 04:14:02 2000 PST | @ 3 mons | Thu Jun 15 04:14:02 2000 PDT
913 | Wed Mar 15 08:14:01 2000 PST | @ 3 mons | Thu Jun 15 08:14:01 2000 PDT
914 | Wed Mar 15 01:14:05 2000 PST | @ 5 mons | Tue Aug 15 01:14:05 2000 PDT
915 | Wed Mar 15 02:14:03 2000 PST | @ 5 mons | Tue Aug 15 02:14:03 2000 PDT
916 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons | Tue Aug 15 03:14:04 2000 PDT
917 | Wed Mar 15 04:14:02 2000 PST | @ 5 mons | Tue Aug 15 04:14:02 2000 PDT
918 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons | Tue Aug 15 08:14:01 2000 PDT
919 | Wed Mar 15 01:14:05 2000 PST | @ 5 mons 12 hours | Tue Aug 15 13:14:05 2000 PDT
920 | Wed Mar 15 02:14:03 2000 PST | @ 5 mons 12 hours | Tue Aug 15 14:14:03 2000 PDT
921 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours | Tue Aug 15 15:14:04 2000 PDT
922 | Wed Mar 15 04:14:02 2000 PST | @ 5 mons 12 hours | Tue Aug 15 16:14:02 2000 PDT
923 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours | Tue Aug 15 20:14:01 2000 PDT
924 | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago | Sun Dec 31 17:31:47 2000 PST
925 | Sun Dec 31 17:32:01 2000 PST | @ 1 min | Sun Dec 31 17:33:01 2000 PST
926 | Sun Dec 31 17:32:01 2000 PST | @ 5 hours | Sun Dec 31 22:32:01 2000 PST
927 | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago | Mon Jan 01 17:31:47 2001 PST
928 | Mon Jan 01 17:32:01 2001 PST | @ 1 min | Mon Jan 01 17:33:01 2001 PST
929 | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Jan 01 19:35:05 2001 PST
930 | Mon Jan 01 17:32:01 2001 PST | @ 5 hours | Mon Jan 01 22:32:01 2001 PST
931 | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Jan 02 19:35:05 2001 PST
932 | Sun Dec 31 17:32:01 2000 PST | @ 10 days | Wed Jan 10 17:32:01 2001 PST
933 | Mon Jan 01 17:32:01 2001 PST | @ 10 days | Thu Jan 11 17:32:01 2001 PST
934 | Sun Dec 31 17:32:01 2000 PST | @ 3 mons | Sat Mar 31 17:32:01 2001 PST
935 | Mon Jan 01 17:32:01 2001 PST | @ 3 mons | Sun Apr 01 17:32:01 2001 PDT
936 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons | Thu May 31 17:32:01 2001 PDT
937 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours | Fri Jun 01 05:32:01 2001 PDT
938 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons | Fri Jun 01 17:32:01 2001 PDT
939 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours | Sat Jun 02 05:32:01 2001 PDT
940 | Wed Feb 28 17:32:01 1996 PST | @ 6 years | Thu Feb 28 17:32:01 2002 PST
941 | Thu Feb 29 17:32:01 1996 PST | @ 6 years | Thu Feb 28 17:32:01 2002 PST
942 | Fri Mar 01 17:32:01 1996 PST | @ 6 years | Fri Mar 01 17:32:01 2002 PST
943 | Mon Dec 30 17:32:01 1996 PST | @ 6 years | Mon Dec 30 17:32:01 2002 PST
944 | Tue Dec 31 17:32:01 1996 PST | @ 6 years | Tue Dec 31 17:32:01 2002 PST
945 | epoch | @ 34 years | Wed Dec 31 16:00:00 2003 PST
946 | Fri Dec 31 17:32:01 1999 PST | @ 6 years | Sat Dec 31 17:32:01 2005 PST
947 | Sat Jan 01 17:32:01 2000 PST | @ 6 years | Sun Jan 01 17:32:01 2006 PST
948 | Wed Mar 15 01:14:05 2000 PST | @ 6 years | Wed Mar 15 01:14:05 2006 PST
949 | Wed Mar 15 02:14:03 2000 PST | @ 6 years | Wed Mar 15 02:14:03 2006 PST
950 | Wed Mar 15 03:14:04 2000 PST | @ 6 years | Wed Mar 15 03:14:04 2006 PST
951 | Wed Mar 15 04:14:02 2000 PST | @ 6 years | Wed Mar 15 04:14:02 2006 PST
952 | Wed Mar 15 08:14:01 2000 PST | @ 6 years | Wed Mar 15 08:14:01 2006 PST
953 | Sun Dec 31 17:32:01 2000 PST | @ 6 years | Sun Dec 31 17:32:01 2006 PST
954 | Mon Jan 01 17:32:01 2001 PST | @ 6 years | Mon Jan 01 17:32:01 2007 PST
955 | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Thu Feb 28 17:32:01 2030 PST
956 | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Thu Feb 28 17:32:01 2030 PST
957 | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Fri Mar 01 17:32:01 2030 PST
958 | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Mon Dec 30 17:32:01 2030 PST
959 | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Tue Dec 31 17:32:01 2030 PST
960 | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Sat Dec 31 17:32:01 2033 PST
961 | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sun Jan 01 17:32:01 2034 PST
962 | Wed Mar 15 01:14:05 2000 PST | @ 34 years | Wed Mar 15 01:14:05 2034 PST
963 | Wed Mar 15 02:14:03 2000 PST | @ 34 years | Wed Mar 15 02:14:03 2034 PST
964 | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Wed Mar 15 03:14:04 2034 PST
965 | Wed Mar 15 04:14:02 2000 PST | @ 34 years | Wed Mar 15 04:14:02 2034 PST
966 | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Wed Mar 15 08:14:01 2034 PST
967 | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sun Dec 31 17:32:01 2034 PST
968 | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Mon Jan 01 17:32:01 2035 PST
971 SELECT '' AS "150", d.f1 AS timestamp, t.f1 AS interval, d.f1 - t.f1 AS minus
972 FROM TEMP_TIMESTAMP d, INTERVAL_TBL t
974 ORDER BY minus, timestamp, interval;
975 150 | timestamp | interval | minus
976 -----+------------------------------+-------------------------------+------------------------------
977 | epoch | @ 34 years | Tue Dec 31 16:00:00 1935 PST
978 | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST
979 | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST
980 | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 17:32:01 1962 PST
981 | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 17:32:01 1962 PST
982 | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 17:32:01 1962 PST
983 | epoch | @ 6 years | Tue Dec 31 16:00:00 1963 PST
984 | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 17:32:01 1965 PST
985 | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 17:32:01 1966 PST
986 | Wed Mar 15 01:14:05 2000 PST | @ 34 years | Tue Mar 15 01:14:05 1966 PST
987 | Wed Mar 15 02:14:03 2000 PST | @ 34 years | Tue Mar 15 02:14:03 1966 PST
988 | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Tue Mar 15 03:14:04 1966 PST
989 | Wed Mar 15 04:14:02 2000 PST | @ 34 years | Tue Mar 15 04:14:02 1966 PST
990 | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 08:14:01 1966 PST
991 | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST
992 | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST
993 | epoch | @ 5 mons 12 hours | Thu Jul 31 04:00:00 1969 PDT
994 | epoch | @ 5 mons | Thu Jul 31 16:00:00 1969 PDT
995 | epoch | @ 3 mons | Tue Sep 30 16:00:00 1969 PDT
996 | epoch | @ 10 days | Sun Dec 21 16:00:00 1969 PST
997 | epoch | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 13:56:56 1969 PST
998 | epoch | @ 5 hours | Wed Dec 31 11:00:00 1969 PST
999 | epoch | @ 1 min | Wed Dec 31 15:59:00 1969 PST
1000 | epoch | @ 14 secs ago | Wed Dec 31 16:00:14 1969 PST
1001 | Wed Feb 28 17:32:01 1996 PST | @ 6 years | Wed Feb 28 17:32:01 1990 PST
1002 | Thu Feb 29 17:32:01 1996 PST | @ 6 years | Wed Feb 28 17:32:01 1990 PST
1003 | Fri Mar 01 17:32:01 1996 PST | @ 6 years | Thu Mar 01 17:32:01 1990 PST
1004 | Mon Dec 30 17:32:01 1996 PST | @ 6 years | Sun Dec 30 17:32:01 1990 PST
1005 | Tue Dec 31 17:32:01 1996 PST | @ 6 years | Mon Dec 31 17:32:01 1990 PST
1006 | Fri Dec 31 17:32:01 1999 PST | @ 6 years | Fri Dec 31 17:32:01 1993 PST
1007 | Sat Jan 01 17:32:01 2000 PST | @ 6 years | Sat Jan 01 17:32:01 1994 PST
1008 | Wed Mar 15 01:14:05 2000 PST | @ 6 years | Tue Mar 15 01:14:05 1994 PST
1009 | Wed Mar 15 02:14:03 2000 PST | @ 6 years | Tue Mar 15 02:14:03 1994 PST
1010 | Wed Mar 15 03:14:04 2000 PST | @ 6 years | Tue Mar 15 03:14:04 1994 PST
1011 | Wed Mar 15 04:14:02 2000 PST | @ 6 years | Tue Mar 15 04:14:02 1994 PST
1012 | Wed Mar 15 08:14:01 2000 PST | @ 6 years | Tue Mar 15 08:14:01 1994 PST
1013 | Sun Dec 31 17:32:01 2000 PST | @ 6 years | Sat Dec 31 17:32:01 1994 PST
1014 | Mon Jan 01 17:32:01 2001 PST | @ 6 years | Sun Jan 01 17:32:01 1995 PST
1015 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours | Thu Sep 28 05:32:01 1995 PDT
1016 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons | Thu Sep 28 17:32:01 1995 PDT
1017 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours | Fri Sep 29 05:32:01 1995 PDT
1018 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons | Fri Sep 29 17:32:01 1995 PDT
1019 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours | Sun Oct 01 05:32:01 1995 PDT
1020 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons | Sun Oct 01 17:32:01 1995 PDT
1021 | Wed Feb 28 17:32:01 1996 PST | @ 3 mons | Tue Nov 28 17:32:01 1995 PST
1022 | Thu Feb 29 17:32:01 1996 PST | @ 3 mons | Wed Nov 29 17:32:01 1995 PST
1023 | Fri Mar 01 17:32:01 1996 PST | @ 3 mons | Fri Dec 01 17:32:01 1995 PST
1024 | Wed Feb 28 17:32:01 1996 PST | @ 10 days | Sun Feb 18 17:32:01 1996 PST
1025 | Thu Feb 29 17:32:01 1996 PST | @ 10 days | Mon Feb 19 17:32:01 1996 PST
1026 | Fri Mar 01 17:32:01 1996 PST | @ 10 days | Tue Feb 20 17:32:01 1996 PST
1027 | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Feb 27 15:28:57 1996 PST
1028 | Wed Feb 28 17:32:01 1996 PST | @ 5 hours | Wed Feb 28 12:32:01 1996 PST
1029 | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Feb 28 15:28:57 1996 PST
1030 | Wed Feb 28 17:32:01 1996 PST | @ 1 min | Wed Feb 28 17:31:01 1996 PST
1031 | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago | Wed Feb 28 17:32:15 1996 PST
1032 | Thu Feb 29 17:32:01 1996 PST | @ 5 hours | Thu Feb 29 12:32:01 1996 PST
1033 | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 15:28:57 1996 PST
1034 | Thu Feb 29 17:32:01 1996 PST | @ 1 min | Thu Feb 29 17:31:01 1996 PST
1035 | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago | Thu Feb 29 17:32:15 1996 PST
1036 | Fri Mar 01 17:32:01 1996 PST | @ 5 hours | Fri Mar 01 12:32:01 1996 PST
1037 | Fri Mar 01 17:32:01 1996 PST | @ 1 min | Fri Mar 01 17:31:01 1996 PST
1038 | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago | Fri Mar 01 17:32:15 1996 PST
1039 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours | Tue Jul 30 05:32:01 1996 PDT
1040 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons | Tue Jul 30 17:32:01 1996 PDT
1041 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours | Wed Jul 31 05:32:01 1996 PDT
1042 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons | Wed Jul 31 17:32:01 1996 PDT
1043 | Mon Dec 30 17:32:01 1996 PST | @ 3 mons | Mon Sep 30 17:32:01 1996 PDT
1044 | Tue Dec 31 17:32:01 1996 PST | @ 3 mons | Mon Sep 30 17:32:01 1996 PDT
1045 | Mon Dec 30 17:32:01 1996 PST | @ 10 days | Fri Dec 20 17:32:01 1996 PST
1046 | Tue Dec 31 17:32:01 1996 PST | @ 10 days | Sat Dec 21 17:32:01 1996 PST
1047 | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 29 15:28:57 1996 PST
1048 | Mon Dec 30 17:32:01 1996 PST | @ 5 hours | Mon Dec 30 12:32:01 1996 PST
1049 | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Dec 30 15:28:57 1996 PST
1050 | Mon Dec 30 17:32:01 1996 PST | @ 1 min | Mon Dec 30 17:31:01 1996 PST
1051 | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago | Mon Dec 30 17:32:15 1996 PST
1052 | Tue Dec 31 17:32:01 1996 PST | @ 5 hours | Tue Dec 31 12:32:01 1996 PST
1053 | Tue Dec 31 17:32:01 1996 PST | @ 1 min | Tue Dec 31 17:31:01 1996 PST
1054 | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago | Tue Dec 31 17:32:15 1996 PST
1055 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours | Sat Jul 31 05:32:01 1999 PDT
1056 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons | Sat Jul 31 17:32:01 1999 PDT
1057 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours | Sun Aug 01 05:32:01 1999 PDT
1058 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons | Sun Aug 01 17:32:01 1999 PDT
1059 | Fri Dec 31 17:32:01 1999 PST | @ 3 mons | Thu Sep 30 17:32:01 1999 PDT
1060 | Sat Jan 01 17:32:01 2000 PST | @ 3 mons | Fri Oct 01 17:32:01 1999 PDT
1061 | Wed Mar 15 01:14:05 2000 PST | @ 5 mons 12 hours | Thu Oct 14 13:14:05 1999 PDT
1062 | Wed Mar 15 02:14:03 2000 PST | @ 5 mons 12 hours | Thu Oct 14 14:14:03 1999 PDT
1063 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours | Thu Oct 14 15:14:04 1999 PDT
1064 | Wed Mar 15 04:14:02 2000 PST | @ 5 mons 12 hours | Thu Oct 14 16:14:02 1999 PDT
1065 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours | Thu Oct 14 20:14:01 1999 PDT
1066 | Wed Mar 15 01:14:05 2000 PST | @ 5 mons | Fri Oct 15 01:14:05 1999 PDT
1067 | Wed Mar 15 02:14:03 2000 PST | @ 5 mons | Fri Oct 15 02:14:03 1999 PDT
1068 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons | Fri Oct 15 03:14:04 1999 PDT
1069 | Wed Mar 15 04:14:02 2000 PST | @ 5 mons | Fri Oct 15 04:14:02 1999 PDT
1070 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons | Fri Oct 15 08:14:01 1999 PDT
1071 | Wed Mar 15 01:14:05 2000 PST | @ 3 mons | Wed Dec 15 01:14:05 1999 PST
1072 | Wed Mar 15 02:14:03 2000 PST | @ 3 mons | Wed Dec 15 02:14:03 1999 PST
1073 | Wed Mar 15 03:14:04 2000 PST | @ 3 mons | Wed Dec 15 03:14:04 1999 PST
1074 | Wed Mar 15 04:14:02 2000 PST | @ 3 mons | Wed Dec 15 04:14:02 1999 PST
1075 | Wed Mar 15 08:14:01 2000 PST | @ 3 mons | Wed Dec 15 08:14:01 1999 PST
1076 | Fri Dec 31 17:32:01 1999 PST | @ 10 days | Tue Dec 21 17:32:01 1999 PST
1077 | Sat Jan 01 17:32:01 2000 PST | @ 10 days | Wed Dec 22 17:32:01 1999 PST
1078 | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Dec 30 15:28:57 1999 PST
1079 | Fri Dec 31 17:32:01 1999 PST | @ 5 hours | Fri Dec 31 12:32:01 1999 PST
1080 | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Dec 31 15:28:57 1999 PST
1081 | Fri Dec 31 17:32:01 1999 PST | @ 1 min | Fri Dec 31 17:31:01 1999 PST
1082 | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago | Fri Dec 31 17:32:15 1999 PST
1083 | Sat Jan 01 17:32:01 2000 PST | @ 5 hours | Sat Jan 01 12:32:01 2000 PST
1084 | Sat Jan 01 17:32:01 2000 PST | @ 1 min | Sat Jan 01 17:31:01 2000 PST
1085 | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago | Sat Jan 01 17:32:15 2000 PST
1086 | Wed Mar 15 01:14:05 2000 PST | @ 10 days | Sun Mar 05 01:14:05 2000 PST
1087 | Wed Mar 15 02:14:03 2000 PST | @ 10 days | Sun Mar 05 02:14:03 2000 PST
1088 | Wed Mar 15 03:14:04 2000 PST | @ 10 days | Sun Mar 05 03:14:04 2000 PST
1089 | Wed Mar 15 04:14:02 2000 PST | @ 10 days | Sun Mar 05 04:14:02 2000 PST
1090 | Wed Mar 15 08:14:01 2000 PST | @ 10 days | Sun Mar 05 08:14:01 2000 PST
1091 | Wed Mar 15 01:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Mar 13 23:11:01 2000 PST
1092 | Wed Mar 15 02:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 00:10:59 2000 PST
1093 | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 01:11:00 2000 PST
1094 | Wed Mar 15 04:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 02:10:58 2000 PST
1095 | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 06:10:57 2000 PST
1096 | Wed Mar 15 01:14:05 2000 PST | @ 5 hours | Tue Mar 14 20:14:05 2000 PST
1097 | Wed Mar 15 02:14:03 2000 PST | @ 5 hours | Tue Mar 14 21:14:03 2000 PST
1098 | Wed Mar 15 03:14:04 2000 PST | @ 5 hours | Tue Mar 14 22:14:04 2000 PST
1099 | Wed Mar 15 04:14:02 2000 PST | @ 5 hours | Tue Mar 14 23:14:02 2000 PST
1100 | Wed Mar 15 01:14:05 2000 PST | @ 1 min | Wed Mar 15 01:13:05 2000 PST
1101 | Wed Mar 15 01:14:05 2000 PST | @ 14 secs ago | Wed Mar 15 01:14:19 2000 PST
1102 | Wed Mar 15 02:14:03 2000 PST | @ 1 min | Wed Mar 15 02:13:03 2000 PST
1103 | Wed Mar 15 02:14:03 2000 PST | @ 14 secs ago | Wed Mar 15 02:14:17 2000 PST
1104 | Wed Mar 15 03:14:04 2000 PST | @ 1 min | Wed Mar 15 03:13:04 2000 PST
1105 | Wed Mar 15 08:14:01 2000 PST | @ 5 hours | Wed Mar 15 03:14:01 2000 PST
1106 | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago | Wed Mar 15 03:14:18 2000 PST
1107 | Wed Mar 15 04:14:02 2000 PST | @ 1 min | Wed Mar 15 04:13:02 2000 PST
1108 | Wed Mar 15 04:14:02 2000 PST | @ 14 secs ago | Wed Mar 15 04:14:16 2000 PST
1109 | Wed Mar 15 08:14:01 2000 PST | @ 1 min | Wed Mar 15 08:13:01 2000 PST
1110 | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago | Wed Mar 15 08:14:15 2000 PST
1111 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours | Mon Jul 31 05:32:01 2000 PDT
1112 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons | Mon Jul 31 17:32:01 2000 PDT
1113 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours | Tue Aug 01 05:32:01 2000 PDT
1114 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons | Tue Aug 01 17:32:01 2000 PDT
1115 | Sun Dec 31 17:32:01 2000 PST | @ 3 mons | Sat Sep 30 17:32:01 2000 PDT
1116 | Mon Jan 01 17:32:01 2001 PST | @ 3 mons | Sun Oct 01 17:32:01 2000 PDT
1117 | Sun Dec 31 17:32:01 2000 PST | @ 10 days | Thu Dec 21 17:32:01 2000 PST
1118 | Mon Jan 01 17:32:01 2001 PST | @ 10 days | Fri Dec 22 17:32:01 2000 PST
1119 | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Dec 30 15:28:57 2000 PST
1120 | Sun Dec 31 17:32:01 2000 PST | @ 5 hours | Sun Dec 31 12:32:01 2000 PST
1121 | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 31 15:28:57 2000 PST
1122 | Sun Dec 31 17:32:01 2000 PST | @ 1 min | Sun Dec 31 17:31:01 2000 PST
1123 | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago | Sun Dec 31 17:32:15 2000 PST
1124 | Mon Jan 01 17:32:01 2001 PST | @ 5 hours | Mon Jan 01 12:32:01 2001 PST
1125 | Mon Jan 01 17:32:01 2001 PST | @ 1 min | Mon Jan 01 17:31:01 2001 PST
1126 | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago | Mon Jan 01 17:32:15 2001 PST
1129 SELECT '' AS "15", d.f1 AS timestamp, timestamp '1980-01-06 00:00 GMT' AS gpstime_zero,
1130 d.f1 - timestamp '1980-01-06 00:00 GMT' AS difference
1131 FROM TEMP_TIMESTAMP d
1132 ORDER BY difference;
1133 15 | timestamp | gpstime_zero | difference
1134 ----+------------------------------+------------------------------+-------------------------------------
1135 | epoch | Sat Jan 05 16:00:00 1980 PST | @ 3657 days ago
1136 | Wed Feb 28 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 5898 days 1 hour 32 mins 1 sec
1137 | Thu Feb 29 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 5899 days 1 hour 32 mins 1 sec
1138 | Fri Mar 01 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 5900 days 1 hour 32 mins 1 sec
1139 | Mon Dec 30 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 6204 days 1 hour 32 mins 1 sec
1140 | Tue Dec 31 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 6205 days 1 hour 32 mins 1 sec
1141 | Fri Dec 31 17:32:01 1999 PST | Sat Jan 05 16:00:00 1980 PST | @ 7300 days 1 hour 32 mins 1 sec
1142 | Sat Jan 01 17:32:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7301 days 1 hour 32 mins 1 sec
1143 | Wed Mar 15 01:14:05 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 9 hours 14 mins 5 secs
1144 | Wed Mar 15 02:14:03 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 10 hours 14 mins 3 secs
1145 | Wed Mar 15 03:14:04 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 11 hours 14 mins 4 secs
1146 | Wed Mar 15 04:14:02 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 12 hours 14 mins 2 secs
1147 | Wed Mar 15 08:14:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 16 hours 14 mins 1 sec
1148 | Sun Dec 31 17:32:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7666 days 1 hour 32 mins 1 sec
1149 | Mon Jan 01 17:32:01 2001 PST | Sat Jan 05 16:00:00 1980 PST | @ 7667 days 1 hour 32 mins 1 sec
1152 SELECT '' AS "225", d1.f1 AS timestamp1, d2.f1 AS timestamp2, d1.f1 - d2.f1 AS difference
1153 FROM TEMP_TIMESTAMP d1, TEMP_TIMESTAMP d2
1154 ORDER BY timestamp1, timestamp2, difference;
1155 225 | timestamp1 | timestamp2 | difference
1156 -----+------------------------------+------------------------------+------------------------------------------
1157 | epoch | epoch | @ 0
1158 | epoch | Wed Feb 28 17:32:01 1996 PST | @ 9555 days 1 hour 32 mins 1 sec ago
1159 | epoch | Thu Feb 29 17:32:01 1996 PST | @ 9556 days 1 hour 32 mins 1 sec ago
1160 | epoch | Fri Mar 01 17:32:01 1996 PST | @ 9557 days 1 hour 32 mins 1 sec ago
1161 | epoch | Mon Dec 30 17:32:01 1996 PST | @ 9861 days 1 hour 32 mins 1 sec ago
1162 | epoch | Tue Dec 31 17:32:01 1996 PST | @ 9862 days 1 hour 32 mins 1 sec ago
1163 | epoch | Fri Dec 31 17:32:01 1999 PST | @ 10957 days 1 hour 32 mins 1 sec ago
1164 | epoch | Sat Jan 01 17:32:01 2000 PST | @ 10958 days 1 hour 32 mins 1 sec ago
1165 | epoch | Wed Mar 15 01:14:05 2000 PST | @ 11031 days 9 hours 14 mins 5 secs ago
1166 | epoch | Wed Mar 15 02:14:03 2000 PST | @ 11031 days 10 hours 14 mins 3 secs ago
1167 | epoch | Wed Mar 15 03:14:04 2000 PST | @ 11031 days 11 hours 14 mins 4 secs ago
1168 | epoch | Wed Mar 15 04:14:02 2000 PST | @ 11031 days 12 hours 14 mins 2 secs ago
1169 | epoch | Wed Mar 15 08:14:01 2000 PST | @ 11031 days 16 hours 14 mins 1 sec ago
1170 | epoch | Sun Dec 31 17:32:01 2000 PST | @ 11323 days 1 hour 32 mins 1 sec ago
1171 | epoch | Mon Jan 01 17:32:01 2001 PST | @ 11324 days 1 hour 32 mins 1 sec ago
1172 | Wed Feb 28 17:32:01 1996 PST | epoch | @ 9555 days 1 hour 32 mins 1 sec
1173 | Wed Feb 28 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 0
1174 | Wed Feb 28 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 1 day ago
1175 | Wed Feb 28 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 2 days ago
1176 | Wed Feb 28 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 306 days ago
1177 | Wed Feb 28 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 307 days ago
1178 | Wed Feb 28 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1402 days ago
1179 | Wed Feb 28 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1403 days ago
1180 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 01:14:05 2000 PST | @ 1476 days 7 hours 42 mins 4 secs ago
1181 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 02:14:03 2000 PST | @ 1476 days 8 hours 42 mins 2 secs ago
1182 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1476 days 9 hours 42 mins 3 secs ago
1183 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 04:14:02 2000 PST | @ 1476 days 10 hours 42 mins 1 sec ago
1184 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1476 days 14 hours 42 mins ago
1185 | Wed Feb 28 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1768 days ago
1186 | Wed Feb 28 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1769 days ago
1187 | Thu Feb 29 17:32:01 1996 PST | epoch | @ 9556 days 1 hour 32 mins 1 sec
1188 | Thu Feb 29 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 1 day
1189 | Thu Feb 29 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 0
1190 | Thu Feb 29 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 1 day ago
1191 | Thu Feb 29 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 305 days ago
1192 | Thu Feb 29 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 306 days ago
1193 | Thu Feb 29 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1401 days ago
1194 | Thu Feb 29 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1402 days ago
1195 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 01:14:05 2000 PST | @ 1475 days 7 hours 42 mins 4 secs ago
1196 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 02:14:03 2000 PST | @ 1475 days 8 hours 42 mins 2 secs ago
1197 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1475 days 9 hours 42 mins 3 secs ago
1198 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 04:14:02 2000 PST | @ 1475 days 10 hours 42 mins 1 sec ago
1199 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1475 days 14 hours 42 mins ago
1200 | Thu Feb 29 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1767 days ago
1201 | Thu Feb 29 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1768 days ago
1202 | Fri Mar 01 17:32:01 1996 PST | epoch | @ 9557 days 1 hour 32 mins 1 sec
1203 | Fri Mar 01 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 2 days
1204 | Fri Mar 01 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 1 day
1205 | Fri Mar 01 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 0
1206 | Fri Mar 01 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 304 days ago
1207 | Fri Mar 01 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 305 days ago
1208 | Fri Mar 01 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1400 days ago
1209 | Fri Mar 01 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1401 days ago
1210 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 01:14:05 2000 PST | @ 1474 days 7 hours 42 mins 4 secs ago
1211 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 02:14:03 2000 PST | @ 1474 days 8 hours 42 mins 2 secs ago
1212 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1474 days 9 hours 42 mins 3 secs ago
1213 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 04:14:02 2000 PST | @ 1474 days 10 hours 42 mins 1 sec ago
1214 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1474 days 14 hours 42 mins ago
1215 | Fri Mar 01 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1766 days ago
1216 | Fri Mar 01 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1767 days ago
1217 | Mon Dec 30 17:32:01 1996 PST | epoch | @ 9861 days 1 hour 32 mins 1 sec
1218 | Mon Dec 30 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 306 days
1219 | Mon Dec 30 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 305 days
1220 | Mon Dec 30 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 304 days
1221 | Mon Dec 30 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 0
1222 | Mon Dec 30 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 1 day ago
1223 | Mon Dec 30 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1096 days ago
1224 | Mon Dec 30 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1097 days ago
1225 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 01:14:05 2000 PST | @ 1170 days 7 hours 42 mins 4 secs ago
1226 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 02:14:03 2000 PST | @ 1170 days 8 hours 42 mins 2 secs ago
1227 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1170 days 9 hours 42 mins 3 secs ago
1228 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 04:14:02 2000 PST | @ 1170 days 10 hours 42 mins 1 sec ago
1229 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1170 days 14 hours 42 mins ago
1230 | Mon Dec 30 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1462 days ago
1231 | Mon Dec 30 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1463 days ago
1232 | Tue Dec 31 17:32:01 1996 PST | epoch | @ 9862 days 1 hour 32 mins 1 sec
1233 | Tue Dec 31 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 307 days
1234 | Tue Dec 31 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 306 days
1235 | Tue Dec 31 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 305 days
1236 | Tue Dec 31 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 1 day
1237 | Tue Dec 31 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 0
1238 | Tue Dec 31 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1095 days ago
1239 | Tue Dec 31 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1096 days ago
1240 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 01:14:05 2000 PST | @ 1169 days 7 hours 42 mins 4 secs ago
1241 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 02:14:03 2000 PST | @ 1169 days 8 hours 42 mins 2 secs ago
1242 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1169 days 9 hours 42 mins 3 secs ago
1243 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 04:14:02 2000 PST | @ 1169 days 10 hours 42 mins 1 sec ago
1244 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1169 days 14 hours 42 mins ago
1245 | Tue Dec 31 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1461 days ago
1246 | Tue Dec 31 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1462 days ago
1247 | Fri Dec 31 17:32:01 1999 PST | epoch | @ 10957 days 1 hour 32 mins 1 sec
1248 | Fri Dec 31 17:32:01 1999 PST | Wed Feb 28 17:32:01 1996 PST | @ 1402 days
1249 | Fri Dec 31 17:32:01 1999 PST | Thu Feb 29 17:32:01 1996 PST | @ 1401 days
1250 | Fri Dec 31 17:32:01 1999 PST | Fri Mar 01 17:32:01 1996 PST | @ 1400 days
1251 | Fri Dec 31 17:32:01 1999 PST | Mon Dec 30 17:32:01 1996 PST | @ 1096 days
1252 | Fri Dec 31 17:32:01 1999 PST | Tue Dec 31 17:32:01 1996 PST | @ 1095 days
1253 | Fri Dec 31 17:32:01 1999 PST | Fri Dec 31 17:32:01 1999 PST | @ 0
1254 | Fri Dec 31 17:32:01 1999 PST | Sat Jan 01 17:32:01 2000 PST | @ 1 day ago
1255 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 01:14:05 2000 PST | @ 74 days 7 hours 42 mins 4 secs ago
1256 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 02:14:03 2000 PST | @ 74 days 8 hours 42 mins 2 secs ago
1257 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 03:14:04 2000 PST | @ 74 days 9 hours 42 mins 3 secs ago
1258 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 04:14:02 2000 PST | @ 74 days 10 hours 42 mins 1 sec ago
1259 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 08:14:01 2000 PST | @ 74 days 14 hours 42 mins ago
1260 | Fri Dec 31 17:32:01 1999 PST | Sun Dec 31 17:32:01 2000 PST | @ 366 days ago
1261 | Fri Dec 31 17:32:01 1999 PST | Mon Jan 01 17:32:01 2001 PST | @ 367 days ago
1262 | Sat Jan 01 17:32:01 2000 PST | epoch | @ 10958 days 1 hour 32 mins 1 sec
1263 | Sat Jan 01 17:32:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1403 days
1264 | Sat Jan 01 17:32:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1402 days
1265 | Sat Jan 01 17:32:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1401 days
1266 | Sat Jan 01 17:32:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1097 days
1267 | Sat Jan 01 17:32:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1096 days
1268 | Sat Jan 01 17:32:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 1 day
1269 | Sat Jan 01 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 0
1270 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 73 days 7 hours 42 mins 4 secs ago
1271 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 73 days 8 hours 42 mins 2 secs ago
1272 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 73 days 9 hours 42 mins 3 secs ago
1273 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 73 days 10 hours 42 mins 1 sec ago
1274 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 73 days 14 hours 42 mins ago
1275 | Sat Jan 01 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 365 days ago
1276 | Sat Jan 01 17:32:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 366 days ago
1277 | Wed Mar 15 01:14:05 2000 PST | epoch | @ 11031 days 9 hours 14 mins 5 secs
1278 | Wed Mar 15 01:14:05 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 7 hours 42 mins 4 secs
1279 | Wed Mar 15 01:14:05 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 7 hours 42 mins 4 secs
1280 | Wed Mar 15 01:14:05 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 7 hours 42 mins 4 secs
1281 | Wed Mar 15 01:14:05 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 7 hours 42 mins 4 secs
1282 | Wed Mar 15 01:14:05 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 7 hours 42 mins 4 secs
1283 | Wed Mar 15 01:14:05 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 7 hours 42 mins 4 secs
1284 | Wed Mar 15 01:14:05 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 7 hours 42 mins 4 secs
1285 | Wed Mar 15 01:14:05 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 0
1286 | Wed Mar 15 01:14:05 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 59 mins 58 secs ago
1287 | Wed Mar 15 01:14:05 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 1 hour 59 mins 59 secs ago
1288 | Wed Mar 15 01:14:05 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 2 hours 59 mins 57 secs ago
1289 | Wed Mar 15 01:14:05 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 6 hours 59 mins 56 secs ago
1290 | Wed Mar 15 01:14:05 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 16 hours 17 mins 56 secs ago
1291 | Wed Mar 15 01:14:05 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 16 hours 17 mins 56 secs ago
1292 | Wed Mar 15 02:14:03 2000 PST | epoch | @ 11031 days 10 hours 14 mins 3 secs
1293 | Wed Mar 15 02:14:03 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 8 hours 42 mins 2 secs
1294 | Wed Mar 15 02:14:03 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 8 hours 42 mins 2 secs
1295 | Wed Mar 15 02:14:03 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 8 hours 42 mins 2 secs
1296 | Wed Mar 15 02:14:03 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 8 hours 42 mins 2 secs
1297 | Wed Mar 15 02:14:03 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 8 hours 42 mins 2 secs
1298 | Wed Mar 15 02:14:03 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 8 hours 42 mins 2 secs
1299 | Wed Mar 15 02:14:03 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 8 hours 42 mins 2 secs
1300 | Wed Mar 15 02:14:03 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 59 mins 58 secs
1301 | Wed Mar 15 02:14:03 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 0
1302 | Wed Mar 15 02:14:03 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 1 hour 1 sec ago
1303 | Wed Mar 15 02:14:03 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 1 hour 59 mins 59 secs ago
1304 | Wed Mar 15 02:14:03 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 59 mins 58 secs ago
1305 | Wed Mar 15 02:14:03 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 15 hours 17 mins 58 secs ago
1306 | Wed Mar 15 02:14:03 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 15 hours 17 mins 58 secs ago
1307 | Wed Mar 15 03:14:04 2000 PST | epoch | @ 11031 days 11 hours 14 mins 4 secs
1308 | Wed Mar 15 03:14:04 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 9 hours 42 mins 3 secs
1309 | Wed Mar 15 03:14:04 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 9 hours 42 mins 3 secs
1310 | Wed Mar 15 03:14:04 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 9 hours 42 mins 3 secs
1311 | Wed Mar 15 03:14:04 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 9 hours 42 mins 3 secs
1312 | Wed Mar 15 03:14:04 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 9 hours 42 mins 3 secs
1313 | Wed Mar 15 03:14:04 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 9 hours 42 mins 3 secs
1314 | Wed Mar 15 03:14:04 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 9 hours 42 mins 3 secs
1315 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 1 hour 59 mins 59 secs
1316 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 1 hour 1 sec
1317 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 0
1318 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 59 mins 58 secs ago
1319 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 59 mins 57 secs ago
1320 | Wed Mar 15 03:14:04 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 14 hours 17 mins 57 secs ago
1321 | Wed Mar 15 03:14:04 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 14 hours 17 mins 57 secs ago
1322 | Wed Mar 15 04:14:02 2000 PST | epoch | @ 11031 days 12 hours 14 mins 2 secs
1323 | Wed Mar 15 04:14:02 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 10 hours 42 mins 1 sec
1324 | Wed Mar 15 04:14:02 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 10 hours 42 mins 1 sec
1325 | Wed Mar 15 04:14:02 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 10 hours 42 mins 1 sec
1326 | Wed Mar 15 04:14:02 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 10 hours 42 mins 1 sec
1327 | Wed Mar 15 04:14:02 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 10 hours 42 mins 1 sec
1328 | Wed Mar 15 04:14:02 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 10 hours 42 mins 1 sec
1329 | Wed Mar 15 04:14:02 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 10 hours 42 mins 1 sec
1330 | Wed Mar 15 04:14:02 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 2 hours 59 mins 57 secs
1331 | Wed Mar 15 04:14:02 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 1 hour 59 mins 59 secs
1332 | Wed Mar 15 04:14:02 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 59 mins 58 secs
1333 | Wed Mar 15 04:14:02 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 0
1334 | Wed Mar 15 04:14:02 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 3 hours 59 mins 59 secs ago
1335 | Wed Mar 15 04:14:02 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 13 hours 17 mins 59 secs ago
1336 | Wed Mar 15 04:14:02 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 13 hours 17 mins 59 secs ago
1337 | Wed Mar 15 08:14:01 2000 PST | epoch | @ 11031 days 16 hours 14 mins 1 sec
1338 | Wed Mar 15 08:14:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 14 hours 42 mins
1339 | Wed Mar 15 08:14:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 14 hours 42 mins
1340 | Wed Mar 15 08:14:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 14 hours 42 mins
1341 | Wed Mar 15 08:14:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 14 hours 42 mins
1342 | Wed Mar 15 08:14:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 14 hours 42 mins
1343 | Wed Mar 15 08:14:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 14 hours 42 mins
1344 | Wed Mar 15 08:14:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 14 hours 42 mins
1345 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 6 hours 59 mins 56 secs
1346 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 5 hours 59 mins 58 secs
1347 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 4 hours 59 mins 57 secs
1348 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 3 hours 59 mins 59 secs
1349 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 0
1350 | Wed Mar 15 08:14:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 9 hours 18 mins ago
1351 | Wed Mar 15 08:14:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 9 hours 18 mins ago
1352 | Sun Dec 31 17:32:01 2000 PST | epoch | @ 11323 days 1 hour 32 mins 1 sec
1353 | Sun Dec 31 17:32:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1768 days
1354 | Sun Dec 31 17:32:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1767 days
1355 | Sun Dec 31 17:32:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1766 days
1356 | Sun Dec 31 17:32:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1462 days
1357 | Sun Dec 31 17:32:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1461 days
1358 | Sun Dec 31 17:32:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 366 days
1359 | Sun Dec 31 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 365 days
1360 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 01:14:05 2000 PST | @ 291 days 16 hours 17 mins 56 secs
1361 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 02:14:03 2000 PST | @ 291 days 15 hours 17 mins 58 secs
1362 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 291 days 14 hours 17 mins 57 secs
1363 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 04:14:02 2000 PST | @ 291 days 13 hours 17 mins 59 secs
1364 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 291 days 9 hours 18 mins
1365 | Sun Dec 31 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 0
1366 | Sun Dec 31 17:32:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 1 day ago
1367 | Mon Jan 01 17:32:01 2001 PST | epoch | @ 11324 days 1 hour 32 mins 1 sec
1368 | Mon Jan 01 17:32:01 2001 PST | Wed Feb 28 17:32:01 1996 PST | @ 1769 days
1369 | Mon Jan 01 17:32:01 2001 PST | Thu Feb 29 17:32:01 1996 PST | @ 1768 days
1370 | Mon Jan 01 17:32:01 2001 PST | Fri Mar 01 17:32:01 1996 PST | @ 1767 days
1371 | Mon Jan 01 17:32:01 2001 PST | Mon Dec 30 17:32:01 1996 PST | @ 1463 days
1372 | Mon Jan 01 17:32:01 2001 PST | Tue Dec 31 17:32:01 1996 PST | @ 1462 days
1373 | Mon Jan 01 17:32:01 2001 PST | Fri Dec 31 17:32:01 1999 PST | @ 367 days
1374 | Mon Jan 01 17:32:01 2001 PST | Sat Jan 01 17:32:01 2000 PST | @ 366 days
1375 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 01:14:05 2000 PST | @ 292 days 16 hours 17 mins 56 secs
1376 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 02:14:03 2000 PST | @ 292 days 15 hours 17 mins 58 secs
1377 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 03:14:04 2000 PST | @ 292 days 14 hours 17 mins 57 secs
1378 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 04:14:02 2000 PST | @ 292 days 13 hours 17 mins 59 secs
1379 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 08:14:01 2000 PST | @ 292 days 9 hours 18 mins
1380 | Mon Jan 01 17:32:01 2001 PST | Sun Dec 31 17:32:01 2000 PST | @ 1 day
1381 | Mon Jan 01 17:32:01 2001 PST | Mon Jan 01 17:32:01 2001 PST | @ 0
1384 SELECT '' as "54", d1 as timestamp,
1385 date_part('year', d1) AS year, date_part('month', d1) AS month,
1386 date_part('day',d1) AS day, date_part('hour', d1) AS hour,
1387 date_part('minute', d1) AS minute, date_part('second', d1) AS second
1389 WHERE isfinite(d1) and d1 >= '1-jan-1900 GMT'
1391 54 | timestamp | year | month | day | hour | minute | second
1392 ----+---------------------------------+------+-------+-----+------+--------+----------
1393 | epoch | 1969 | 12 | 31 | 16 | 0 | 0
1394 | Wed Feb 28 17:32:01 1996 PST | 1996 | 2 | 28 | 17 | 32 | 1
1395 | Thu Feb 29 17:32:01 1996 PST | 1996 | 2 | 29 | 17 | 32 | 1
1396 | Fri Mar 01 17:32:01 1996 PST | 1996 | 3 | 1 | 17 | 32 | 1
1397 | Mon Dec 30 17:32:01 1996 PST | 1996 | 12 | 30 | 17 | 32 | 1
1398 | Tue Dec 31 17:32:01 1996 PST | 1996 | 12 | 31 | 17 | 32 | 1
1399 | Wed Jan 01 17:32:01 1997 PST | 1997 | 1 | 1 | 17 | 32 | 1
1400 | Thu Jan 02 00:00:00 1997 PST | 1997 | 1 | 2 | 0 | 0 | 0
1401 | Thu Jan 02 03:04:05 1997 PST | 1997 | 1 | 2 | 3 | 4 | 5
1402 | Mon Feb 10 09:32:01 1997 PST | 1997 | 2 | 10 | 9 | 32 | 1
1403 | Mon Feb 10 09:32:01 1997 PST | 1997 | 2 | 10 | 9 | 32 | 1
1404 | Mon Feb 10 09:32:01 1997 PST | 1997 | 2 | 10 | 9 | 32 | 1
1405 | Mon Feb 10 17:32:00 1997 PST | 1997 | 2 | 10 | 17 | 32 | 0
1406 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1407 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1408 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1409 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1410 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1411 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1412 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1413 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1414 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1415 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1416 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1417 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1418 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1
1419 | Mon Feb 10 17:32:01.00 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.000001
1420 | Mon Feb 10 17:32:01.40 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.4
1421 | Mon Feb 10 17:32:01.50 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.5
1422 | Mon Feb 10 17:32:01.60 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.6
1423 | Mon Feb 10 17:32:02.00 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.999999
1424 | Tue Feb 11 17:32:01 1997 PST | 1997 | 2 | 11 | 17 | 32 | 1
1425 | Wed Feb 12 17:32:01 1997 PST | 1997 | 2 | 12 | 17 | 32 | 1
1426 | Thu Feb 13 17:32:01 1997 PST | 1997 | 2 | 13 | 17 | 32 | 1
1427 | Fri Feb 14 17:32:01 1997 PST | 1997 | 2 | 14 | 17 | 32 | 1
1428 | Sat Feb 15 17:32:01 1997 PST | 1997 | 2 | 15 | 17 | 32 | 1
1429 | Sun Feb 16 17:32:01 1997 PST | 1997 | 2 | 16 | 17 | 32 | 1
1430 | Sun Feb 16 17:32:01 1997 PST | 1997 | 2 | 16 | 17 | 32 | 1
1431 | Fri Feb 28 17:32:01 1997 PST | 1997 | 2 | 28 | 17 | 32 | 1
1432 | Sat Mar 01 17:32:01 1997 PST | 1997 | 3 | 1 | 17 | 32 | 1
1433 | Tue Jun 10 17:32:01 1997 PDT | 1997 | 6 | 10 | 17 | 32 | 1
1434 | Tue Jun 10 18:32:01 1997 PDT | 1997 | 6 | 10 | 18 | 32 | 1
1435 | Tue Dec 30 17:32:01 1997 PST | 1997 | 12 | 30 | 17 | 32 | 1
1436 | Wed Dec 31 17:32:01 1997 PST | 1997 | 12 | 31 | 17 | 32 | 1
1437 | Fri Dec 31 17:32:01 1999 PST | 1999 | 12 | 31 | 17 | 32 | 1
1438 | Sat Jan 01 17:32:01 2000 PST | 2000 | 1 | 1 | 17 | 32 | 1
1439 | Wed Mar 15 01:14:05 2000 PST | 2000 | 3 | 15 | 1 | 14 | 5
1440 | Wed Mar 15 02:14:03 2000 PST | 2000 | 3 | 15 | 2 | 14 | 3
1441 | Wed Mar 15 03:14:04 2000 PST | 2000 | 3 | 15 | 3 | 14 | 4
1442 | Wed Mar 15 04:14:02 2000 PST | 2000 | 3 | 15 | 4 | 14 | 2
1443 | Wed Mar 15 08:14:01 2000 PST | 2000 | 3 | 15 | 8 | 14 | 1
1444 | Sun Dec 31 17:32:01 2000 PST | 2000 | 12 | 31 | 17 | 32 | 1
1445 | Mon Jan 01 17:32:01 2001 PST | 2001 | 1 | 1 | 17 | 32 | 1
1446 | Sat Feb 16 17:32:01 2097 | 2097 | 2 | 16 | 17 | 32 | 1
1450 -- abstime, reltime arithmetic
1452 SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime
1453 WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1)
1454 < abstime 'Jan 14 14:00:00 1971'
1455 ORDER BY abstime, reltime;
1456 ten | abstime | reltime
1457 -----+------------------------------+---------------
1458 | Sat May 10 23:59:12 1947 PST | @ 14 secs ago
1459 | Sat May 10 23:59:12 1947 PST | @ 1 min
1460 | Sat May 10 23:59:12 1947 PST | @ 5 hours
1461 | Sat May 10 23:59:12 1947 PST | @ 10 days
1462 | Sat May 10 23:59:12 1947 PST | @ 3 mons
1463 | epoch | @ 14 secs ago
1470 -- these four queries should return the same answer
1471 -- the "infinity" and "-infinity" tuples in ABSTIME_TBL cannot be added and
1472 -- therefore, should not show up in the results.
1473 SELECT '' AS three, ABSTIME_TBL.*
1474 WHERE (ABSTIME_TBL.f1 + reltime '@ 3 year') -- +3 years
1475 < abstime 'Jan 14 14:00:00 1977';
1477 -------+------------------------------
1478 | Sun Jan 14 03:14:21 1973 PST
1480 | Sat May 10 23:59:12 1947 PST
1483 SELECT '' AS three, ABSTIME_TBL.*
1484 WHERE (ABSTIME_TBL.f1 + reltime '@ 3 year ago') -- -3 years
1485 < abstime 'Jan 14 14:00:00 1971';
1487 -------+------------------------------
1488 | Sun Jan 14 03:14:21 1973 PST
1490 | Sat May 10 23:59:12 1947 PST
1493 SELECT '' AS three, ABSTIME_TBL.*
1494 WHERE (ABSTIME_TBL.f1 - reltime '@ 3 year') -- -(+3) years
1495 < abstime 'Jan 14 14:00:00 1971';
1497 -------+------------------------------
1498 | Sun Jan 14 03:14:21 1973 PST
1500 | Sat May 10 23:59:12 1947 PST
1503 SELECT '' AS three, ABSTIME_TBL.*
1504 WHERE (ABSTIME_TBL.f1 - reltime '@ 3 year ago') -- -(-3) years
1505 < abstime 'Jan 14 14:00:00 1977';
1507 -------+------------------------------
1508 | Sun Jan 14 03:14:21 1973 PST
1510 | Sat May 10 23:59:12 1947 PST
1516 SELECT '' AS "15", f1 AS timestamp, date( f1) AS date
1518 WHERE f1 <> timestamp 'current'
1519 ORDER BY date, timestamp;
1520 15 | timestamp | date
1521 ----+------------------------------+------------
1522 | epoch | 01-01-1970
1523 | Wed Feb 28 17:32:01 1996 PST | 02-28-1996
1524 | Thu Feb 29 17:32:01 1996 PST | 02-29-1996
1525 | Fri Mar 01 17:32:01 1996 PST | 03-01-1996
1526 | Mon Dec 30 17:32:01 1996 PST | 12-30-1996
1527 | Tue Dec 31 17:32:01 1996 PST | 12-31-1996
1528 | Fri Dec 31 17:32:01 1999 PST | 12-31-1999
1529 | Sat Jan 01 17:32:01 2000 PST | 01-01-2000
1530 | Wed Mar 15 01:14:05 2000 PST | 03-15-2000
1531 | Wed Mar 15 02:14:03 2000 PST | 03-15-2000
1532 | Wed Mar 15 03:14:04 2000 PST | 03-15-2000
1533 | Wed Mar 15 04:14:02 2000 PST | 03-15-2000
1534 | Wed Mar 15 08:14:01 2000 PST | 03-15-2000
1535 | Sun Dec 31 17:32:01 2000 PST | 12-31-2000
1536 | Mon Jan 01 17:32:01 2001 PST | 01-01-2001
1539 SELECT '' AS "15", f1 AS timestamp, abstime( f1) AS abstime
1542 15 | timestamp | abstime
1543 ----+------------------------------+------------------------------
1545 | Wed Feb 28 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST
1546 | Thu Feb 29 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST
1547 | Fri Mar 01 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST
1548 | Mon Dec 30 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST
1549 | Tue Dec 31 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST
1550 | Fri Dec 31 17:32:01 1999 PST | Fri Dec 31 17:32:01 1999 PST
1551 | Sat Jan 01 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST
1552 | Wed Mar 15 01:14:05 2000 PST | Wed Mar 15 01:14:05 2000 PST
1553 | Wed Mar 15 02:14:03 2000 PST | Wed Mar 15 02:14:03 2000 PST
1554 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST
1555 | Wed Mar 15 04:14:02 2000 PST | Wed Mar 15 04:14:02 2000 PST
1556 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST
1557 | Sun Dec 31 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST
1558 | Mon Jan 01 17:32:01 2001 PST | Mon Jan 01 17:32:01 2001 PST
1561 SELECT '' AS four, f1 AS abstime, date( f1) AS date
1563 WHERE isfinite(f1) AND f1 <> abstime 'current'
1564 ORDER BY date, abstime;
1565 four | abstime | date
1566 ------+------------------------------+------------
1567 | Sat May 10 23:59:12 1947 PST | 05-10-1947
1568 | epoch | 01-01-1970
1569 | Sun Jan 14 03:14:21 1973 PST | 01-14-1973
1570 | Mon May 01 00:30:30 1995 PDT | 05-01-1995
1573 SELECT '' AS five, d1 AS timestamp, abstime(d1) AS abstime
1574 FROM TIMESTAMP_TBL WHERE NOT isfinite(d1);
1575 five | timestamp | abstime
1576 ------+-----------+-----------
1578 | -infinity | -infinity
1579 | infinity | infinity
1584 SELECT '' AS three, f1 as abstime, timestamp(f1) AS timestamp
1585 FROM ABSTIME_TBL WHERE NOT isfinite(f1);
1586 three | abstime | timestamp
1587 -------+-----------+-----------
1588 | infinity | infinity
1589 | -infinity | -infinity
1593 SELECT '' AS ten, f1 AS interval, reltime( f1) AS reltime
1595 ten | interval | reltime
1596 -----+-------------------------------+-------------------------------
1598 | @ 5 hours | @ 5 hours
1599 | @ 10 days | @ 10 days
1600 | @ 34 years | @ 34 years
1601 | @ 3 mons | @ 3 mons
1602 | @ 14 secs ago | @ 14 secs ago
1603 | @ 1 day 2 hours 3 mins 4 secs | @ 1 day 2 hours 3 mins 4 secs
1604 | @ 6 years | @ 6 years
1605 | @ 5 mons | @ 5 mons
1606 | @ 5 mons 12 hours | @ 5 mons 12 hours
1609 SELECT '' AS six, f1 as reltime, interval( f1) AS interval
1611 six | reltime | interval
1612 -----+---------------+---------------
1614 | @ 5 hours | @ 5 hours
1615 | @ 10 days | @ 10 days
1616 | @ 34 years | @ 34 years
1617 | @ 3 mons | @ 3 mons
1618 | @ 14 secs ago | @ 14 secs ago
1621 DROP TABLE TEMP_TIMESTAMP;
1625 SET DateStyle TO 'US,Postgres';
1627 NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
1628 SELECT '' AS "66", d1 AS us_postgres FROM TIMESTAMP_TBL;
1630 ----+---------------------------------
1635 | Mon Feb 10 17:32:01 1997 PST
1638 | Mon Feb 10 17:32:01.00 1997 PST
1639 | Mon Feb 10 17:32:02.00 1997 PST
1640 | Mon Feb 10 17:32:01.40 1997 PST
1641 | Mon Feb 10 17:32:01.50 1997 PST
1642 | Mon Feb 10 17:32:01.60 1997 PST
1643 | Thu Jan 02 00:00:00 1997 PST
1644 | Thu Jan 02 03:04:05 1997 PST
1645 | Mon Feb 10 17:32:01 1997 PST
1646 | Mon Feb 10 17:32:01 1997 PST
1647 | Mon Feb 10 17:32:01 1997 PST
1648 | Mon Feb 10 17:32:01 1997 PST
1649 | Tue Jun 10 17:32:01 1997 PDT
1650 | Wed Mar 15 08:14:01 2000 PST
1651 | Wed Mar 15 04:14:02 2000 PST
1652 | Wed Mar 15 02:14:03 2000 PST
1653 | Wed Mar 15 03:14:04 2000 PST
1654 | Wed Mar 15 01:14:05 2000 PST
1655 | Mon Feb 10 17:32:01 1997 PST
1656 | Mon Feb 10 17:32:01 1997 PST
1657 | Mon Feb 10 17:32:00 1997 PST
1658 | Mon Feb 10 17:32:01 1997 PST
1659 | Mon Feb 10 17:32:01 1997 PST
1660 | Mon Feb 10 17:32:01 1997 PST
1661 | Mon Feb 10 17:32:01 1997 PST
1662 | Mon Feb 10 17:32:01 1997 PST
1663 | Mon Feb 10 09:32:01 1997 PST
1664 | Mon Feb 10 09:32:01 1997 PST
1665 | Mon Feb 10 09:32:01 1997 PST
1666 | Tue Jun 10 18:32:01 1997 PDT
1667 | Mon Feb 10 17:32:01 1997 PST
1668 | Tue Feb 11 17:32:01 1997 PST
1669 | Wed Feb 12 17:32:01 1997 PST
1670 | Thu Feb 13 17:32:01 1997 PST
1671 | Fri Feb 14 17:32:01 1997 PST
1672 | Sat Feb 15 17:32:01 1997 PST
1673 | Sun Feb 16 17:32:01 1997 PST
1674 | Tue Feb 16 17:32 0097 BC
1675 | Sat Feb 16 17:32:01 0097
1676 | Thu Feb 16 17:32:01 0597
1677 | Tue Feb 16 17:32:01 1097
1678 | Sat Feb 16 17:32:01 1697
1679 | Thu Feb 16 17:32:01 1797
1680 | Tue Feb 16 17:32:01 1897
1681 | Sun Feb 16 17:32:01 1997 PST
1682 | Sat Feb 16 17:32:01 2097
1683 | Wed Feb 28 17:32:01 1996 PST
1684 | Thu Feb 29 17:32:01 1996 PST
1685 | Fri Mar 01 17:32:01 1996 PST
1686 | Mon Dec 30 17:32:01 1996 PST
1687 | Tue Dec 31 17:32:01 1996 PST
1688 | Wed Jan 01 17:32:01 1997 PST
1689 | Fri Feb 28 17:32:01 1997 PST
1690 | Sat Mar 01 17:32:01 1997 PST
1691 | Tue Dec 30 17:32:01 1997 PST
1692 | Wed Dec 31 17:32:01 1997 PST
1693 | Fri Dec 31 17:32:01 1999 PST
1694 | Sat Jan 01 17:32:01 2000 PST
1695 | Sun Dec 31 17:32:01 2000 PST
1696 | Mon Jan 01 17:32:01 2001 PST
1699 SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL;
1701 -------+------------------------------
1702 | Sun Jan 14 03:14:21 1973 PST
1703 | Mon May 01 00:30:30 1995 PDT
1708 | Sat May 10 23:59:12 1947 PST
1712 SET DateStyle TO 'US,ISO';
1713 SELECT '' AS "66", d1 AS us_iso FROM TIMESTAMP_TBL;
1715 ----+---------------------------
1720 | 1997-02-10 17:32:01-08
1723 | 1997-02-10 17:32:01.00-08
1724 | 1997-02-10 17:32:02.00-08
1725 | 1997-02-10 17:32:01.40-08
1726 | 1997-02-10 17:32:01.50-08
1727 | 1997-02-10 17:32:01.60-08
1728 | 1997-01-02 00:00:00-08
1729 | 1997-01-02 03:04:05-08
1730 | 1997-02-10 17:32:01-08
1731 | 1997-02-10 17:32:01-08
1732 | 1997-02-10 17:32:01-08
1733 | 1997-02-10 17:32:01-08
1734 | 1997-06-10 17:32:01-07
1735 | 2000-03-15 08:14:01-08
1736 | 2000-03-15 04:14:02-08
1737 | 2000-03-15 02:14:03-08
1738 | 2000-03-15 03:14:04-08
1739 | 2000-03-15 01:14:05-08
1740 | 1997-02-10 17:32:01-08
1741 | 1997-02-10 17:32:01-08
1742 | 1997-02-10 17:32:00-08
1743 | 1997-02-10 17:32:01-08
1744 | 1997-02-10 17:32:01-08
1745 | 1997-02-10 17:32:01-08
1746 | 1997-02-10 17:32:01-08
1747 | 1997-02-10 17:32:01-08
1748 | 1997-02-10 09:32:01-08
1749 | 1997-02-10 09:32:01-08
1750 | 1997-02-10 09:32:01-08
1751 | 1997-06-10 18:32:01-07
1752 | 1997-02-10 17:32:01-08
1753 | 1997-02-11 17:32:01-08
1754 | 1997-02-12 17:32:01-08
1755 | 1997-02-13 17:32:01-08
1756 | 1997-02-14 17:32:01-08
1757 | 1997-02-15 17:32:01-08
1758 | 1997-02-16 17:32:01-08
1759 | 0097-02-16 17:32 BC
1760 | 0097-02-16 17:32:01
1761 | 0597-02-16 17:32:01
1762 | 1097-02-16 17:32:01
1763 | 1697-02-16 17:32:01
1764 | 1797-02-16 17:32:01
1765 | 1897-02-16 17:32:01
1766 | 1997-02-16 17:32:01-08
1767 | 2097-02-16 17:32:01
1768 | 1996-02-28 17:32:01-08
1769 | 1996-02-29 17:32:01-08
1770 | 1996-03-01 17:32:01-08
1771 | 1996-12-30 17:32:01-08
1772 | 1996-12-31 17:32:01-08
1773 | 1997-01-01 17:32:01-08
1774 | 1997-02-28 17:32:01-08
1775 | 1997-03-01 17:32:01-08
1776 | 1997-12-30 17:32:01-08
1777 | 1997-12-31 17:32:01-08
1778 | 1999-12-31 17:32:01-08
1779 | 2000-01-01 17:32:01-08
1780 | 2000-12-31 17:32:01-08
1781 | 2001-01-01 17:32:01-08
1784 SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL;
1786 -------+------------------------
1787 | 1973-01-14 03:14:21-08
1788 | 1995-05-01 00:30:30-07
1793 | 1947-05-10 23:59:12-08
1797 SET DateStyle TO 'US,SQL';
1799 NOTICE: DateStyle is SQL with US (NonEuropean) conventions
1800 SELECT '' AS "66", d1 AS us_sql FROM TIMESTAMP_TBL;
1802 ----+----------------------------
1807 | 02/10/1997 17:32:01.00 PST
1810 | 02/10/1997 17:32:01.00 PST
1811 | 02/10/1997 17:32:02.00 PST
1812 | 02/10/1997 17:32:01.40 PST
1813 | 02/10/1997 17:32:01.50 PST
1814 | 02/10/1997 17:32:01.60 PST
1815 | 01/02/1997 00:00:00.00 PST
1816 | 01/02/1997 03:04:05.00 PST
1817 | 02/10/1997 17:32:01.00 PST
1818 | 02/10/1997 17:32:01.00 PST
1819 | 02/10/1997 17:32:01.00 PST
1820 | 02/10/1997 17:32:01.00 PST
1821 | 06/10/1997 17:32:01.00 PDT
1822 | 03/15/2000 08:14:01.00 PST
1823 | 03/15/2000 04:14:02.00 PST
1824 | 03/15/2000 02:14:03.00 PST
1825 | 03/15/2000 03:14:04.00 PST
1826 | 03/15/2000 01:14:05.00 PST
1827 | 02/10/1997 17:32:01.00 PST
1828 | 02/10/1997 17:32:01.00 PST
1829 | 02/10/1997 17:32:00.00 PST
1830 | 02/10/1997 17:32:01.00 PST
1831 | 02/10/1997 17:32:01.00 PST
1832 | 02/10/1997 17:32:01.00 PST
1833 | 02/10/1997 17:32:01.00 PST
1834 | 02/10/1997 17:32:01.00 PST
1835 | 02/10/1997 09:32:01.00 PST
1836 | 02/10/1997 09:32:01.00 PST
1837 | 02/10/1997 09:32:01.00 PST
1838 | 06/10/1997 18:32:01.00 PDT
1839 | 02/10/1997 17:32:01.00 PST
1840 | 02/11/1997 17:32:01.00 PST
1841 | 02/12/1997 17:32:01.00 PST
1842 | 02/13/1997 17:32:01.00 PST
1843 | 02/14/1997 17:32:01.00 PST
1844 | 02/15/1997 17:32:01.00 PST
1845 | 02/16/1997 17:32:01.00 PST
1846 | 02/16/0097 17:32 BC
1847 | 02/16/0097 17:32:01.00
1848 | 02/16/0597 17:32:01.00
1849 | 02/16/1097 17:32:01.00
1850 | 02/16/1697 17:32:01.00
1851 | 02/16/1797 17:32:01.00
1852 | 02/16/1897 17:32:01.00
1853 | 02/16/1997 17:32:01.00 PST
1854 | 02/16/2097 17:32:01.00
1855 | 02/28/1996 17:32:01.00 PST
1856 | 02/29/1996 17:32:01.00 PST
1857 | 03/01/1996 17:32:01.00 PST
1858 | 12/30/1996 17:32:01.00 PST
1859 | 12/31/1996 17:32:01.00 PST
1860 | 01/01/1997 17:32:01.00 PST
1861 | 02/28/1997 17:32:01.00 PST
1862 | 03/01/1997 17:32:01.00 PST
1863 | 12/30/1997 17:32:01.00 PST
1864 | 12/31/1997 17:32:01.00 PST
1865 | 12/31/1999 17:32:01.00 PST
1866 | 01/01/2000 17:32:01.00 PST
1867 | 12/31/2000 17:32:01.00 PST
1868 | 01/01/2001 17:32:01.00 PST
1871 SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL;
1873 -------+----------------------------
1874 | 01/14/1973 03:14:21.00 PST
1875 | 05/01/1995 00:30:30.00 PDT
1880 | 05/10/1947 23:59:12.00 PST
1884 SET DateStyle TO 'European,Postgres';
1886 NOTICE: DateStyle is Postgres with European conventions
1887 INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957');
1888 SELECT count(*) as one FROM TIMESTAMP_TBL WHERE d1 = 'Jun 13 1957';
1894 SELECT '' AS "67", d1 AS european_postgres FROM TIMESTAMP_TBL;
1895 67 | european_postgres
1896 ----+---------------------------------
1901 | Mon 10 Feb 17:32:01 1997 PST
1904 | Mon 10 Feb 17:32:01.00 1997 PST
1905 | Mon 10 Feb 17:32:02.00 1997 PST
1906 | Mon 10 Feb 17:32:01.40 1997 PST
1907 | Mon 10 Feb 17:32:01.50 1997 PST
1908 | Mon 10 Feb 17:32:01.60 1997 PST
1909 | Thu 02 Jan 00:00:00 1997 PST
1910 | Thu 02 Jan 03:04:05 1997 PST
1911 | Mon 10 Feb 17:32:01 1997 PST
1912 | Mon 10 Feb 17:32:01 1997 PST
1913 | Mon 10 Feb 17:32:01 1997 PST
1914 | Mon 10 Feb 17:32:01 1997 PST
1915 | Tue 10 Jun 17:32:01 1997 PDT
1916 | Wed 15 Mar 08:14:01 2000 PST
1917 | Wed 15 Mar 04:14:02 2000 PST
1918 | Wed 15 Mar 02:14:03 2000 PST
1919 | Wed 15 Mar 03:14:04 2000 PST
1920 | Wed 15 Mar 01:14:05 2000 PST
1921 | Mon 10 Feb 17:32:01 1997 PST
1922 | Mon 10 Feb 17:32:01 1997 PST
1923 | Mon 10 Feb 17:32:00 1997 PST
1924 | Mon 10 Feb 17:32:01 1997 PST
1925 | Mon 10 Feb 17:32:01 1997 PST
1926 | Mon 10 Feb 17:32:01 1997 PST
1927 | Mon 10 Feb 17:32:01 1997 PST
1928 | Mon 10 Feb 17:32:01 1997 PST
1929 | Mon 10 Feb 09:32:01 1997 PST
1930 | Mon 10 Feb 09:32:01 1997 PST
1931 | Mon 10 Feb 09:32:01 1997 PST
1932 | Tue 10 Jun 18:32:01 1997 PDT
1933 | Mon 10 Feb 17:32:01 1997 PST
1934 | Tue 11 Feb 17:32:01 1997 PST
1935 | Wed 12 Feb 17:32:01 1997 PST
1936 | Thu 13 Feb 17:32:01 1997 PST
1937 | Fri 14 Feb 17:32:01 1997 PST
1938 | Sat 15 Feb 17:32:01 1997 PST
1939 | Sun 16 Feb 17:32:01 1997 PST
1940 | Tue 16 Feb 17:32 0097 BC
1941 | Sat 16 Feb 17:32:01 0097
1942 | Thu 16 Feb 17:32:01 0597
1943 | Tue 16 Feb 17:32:01 1097
1944 | Sat 16 Feb 17:32:01 1697
1945 | Thu 16 Feb 17:32:01 1797
1946 | Tue 16 Feb 17:32:01 1897
1947 | Sun 16 Feb 17:32:01 1997 PST
1948 | Sat 16 Feb 17:32:01 2097
1949 | Wed 28 Feb 17:32:01 1996 PST
1950 | Thu 29 Feb 17:32:01 1996 PST
1951 | Fri 01 Mar 17:32:01 1996 PST
1952 | Mon 30 Dec 17:32:01 1996 PST
1953 | Tue 31 Dec 17:32:01 1996 PST
1954 | Wed 01 Jan 17:32:01 1997 PST
1955 | Fri 28 Feb 17:32:01 1997 PST
1956 | Sat 01 Mar 17:32:01 1997 PST
1957 | Tue 30 Dec 17:32:01 1997 PST
1958 | Wed 31 Dec 17:32:01 1997 PST
1959 | Fri 31 Dec 17:32:01 1999 PST
1960 | Sat 01 Jan 17:32:01 2000 PST
1961 | Sun 31 Dec 17:32:01 2000 PST
1962 | Mon 01 Jan 17:32:01 2001 PST
1963 | Thu 13 Jun 00:00:00 1957 PDT
1966 SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
1967 eight | european_postgres
1968 -------+------------------------------
1969 | Sun 14 Jan 03:14:21 1973 PST
1970 | Mon 01 May 00:30:30 1995 PDT
1975 | Sat 10 May 23:59:12 1947 PST
1979 SET DateStyle TO 'European,ISO';
1981 NOTICE: DateStyle is ISO with European conventions
1982 SELECT '' AS "67", d1 AS european_iso FROM TIMESTAMP_TBL;
1984 ----+---------------------------
1989 | 1997-02-10 17:32:01-08
1992 | 1997-02-10 17:32:01.00-08
1993 | 1997-02-10 17:32:02.00-08
1994 | 1997-02-10 17:32:01.40-08
1995 | 1997-02-10 17:32:01.50-08
1996 | 1997-02-10 17:32:01.60-08
1997 | 1997-01-02 00:00:00-08
1998 | 1997-01-02 03:04:05-08
1999 | 1997-02-10 17:32:01-08
2000 | 1997-02-10 17:32:01-08
2001 | 1997-02-10 17:32:01-08
2002 | 1997-02-10 17:32:01-08
2003 | 1997-06-10 17:32:01-07
2004 | 2000-03-15 08:14:01-08
2005 | 2000-03-15 04:14:02-08
2006 | 2000-03-15 02:14:03-08
2007 | 2000-03-15 03:14:04-08
2008 | 2000-03-15 01:14:05-08
2009 | 1997-02-10 17:32:01-08
2010 | 1997-02-10 17:32:01-08
2011 | 1997-02-10 17:32:00-08
2012 | 1997-02-10 17:32:01-08
2013 | 1997-02-10 17:32:01-08
2014 | 1997-02-10 17:32:01-08
2015 | 1997-02-10 17:32:01-08
2016 | 1997-02-10 17:32:01-08
2017 | 1997-02-10 09:32:01-08
2018 | 1997-02-10 09:32:01-08
2019 | 1997-02-10 09:32:01-08
2020 | 1997-06-10 18:32:01-07
2021 | 1997-02-10 17:32:01-08
2022 | 1997-02-11 17:32:01-08
2023 | 1997-02-12 17:32:01-08
2024 | 1997-02-13 17:32:01-08
2025 | 1997-02-14 17:32:01-08
2026 | 1997-02-15 17:32:01-08
2027 | 1997-02-16 17:32:01-08
2028 | 0097-02-16 17:32 BC
2029 | 0097-02-16 17:32:01
2030 | 0597-02-16 17:32:01
2031 | 1097-02-16 17:32:01
2032 | 1697-02-16 17:32:01
2033 | 1797-02-16 17:32:01
2034 | 1897-02-16 17:32:01
2035 | 1997-02-16 17:32:01-08
2036 | 2097-02-16 17:32:01
2037 | 1996-02-28 17:32:01-08
2038 | 1996-02-29 17:32:01-08
2039 | 1996-03-01 17:32:01-08
2040 | 1996-12-30 17:32:01-08
2041 | 1996-12-31 17:32:01-08
2042 | 1997-01-01 17:32:01-08
2043 | 1997-02-28 17:32:01-08
2044 | 1997-03-01 17:32:01-08
2045 | 1997-12-30 17:32:01-08
2046 | 1997-12-31 17:32:01-08
2047 | 1999-12-31 17:32:01-08
2048 | 2000-01-01 17:32:01-08
2049 | 2000-12-31 17:32:01-08
2050 | 2001-01-01 17:32:01-08
2051 | 1957-06-13 00:00:00-07
2054 SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
2055 eight | european_iso
2056 -------+------------------------
2057 | 1973-01-14 03:14:21-08
2058 | 1995-05-01 00:30:30-07
2063 | 1947-05-10 23:59:12-08
2067 SET DateStyle TO 'European,SQL';
2069 NOTICE: DateStyle is SQL with European conventions
2070 SELECT '' AS "67", d1 AS european_sql FROM TIMESTAMP_TBL;
2072 ----+----------------------------
2077 | 10/02/1997 17:32:01.00 PST
2080 | 10/02/1997 17:32:01.00 PST
2081 | 10/02/1997 17:32:02.00 PST
2082 | 10/02/1997 17:32:01.40 PST
2083 | 10/02/1997 17:32:01.50 PST
2084 | 10/02/1997 17:32:01.60 PST
2085 | 02/01/1997 00:00:00.00 PST
2086 | 02/01/1997 03:04:05.00 PST
2087 | 10/02/1997 17:32:01.00 PST
2088 | 10/02/1997 17:32:01.00 PST
2089 | 10/02/1997 17:32:01.00 PST
2090 | 10/02/1997 17:32:01.00 PST
2091 | 10/06/1997 17:32:01.00 PDT
2092 | 15/03/2000 08:14:01.00 PST
2093 | 15/03/2000 04:14:02.00 PST
2094 | 15/03/2000 02:14:03.00 PST
2095 | 15/03/2000 03:14:04.00 PST
2096 | 15/03/2000 01:14:05.00 PST
2097 | 10/02/1997 17:32:01.00 PST
2098 | 10/02/1997 17:32:01.00 PST
2099 | 10/02/1997 17:32:00.00 PST
2100 | 10/02/1997 17:32:01.00 PST
2101 | 10/02/1997 17:32:01.00 PST
2102 | 10/02/1997 17:32:01.00 PST
2103 | 10/02/1997 17:32:01.00 PST
2104 | 10/02/1997 17:32:01.00 PST
2105 | 10/02/1997 09:32:01.00 PST
2106 | 10/02/1997 09:32:01.00 PST
2107 | 10/02/1997 09:32:01.00 PST
2108 | 10/06/1997 18:32:01.00 PDT
2109 | 10/02/1997 17:32:01.00 PST
2110 | 11/02/1997 17:32:01.00 PST
2111 | 12/02/1997 17:32:01.00 PST
2112 | 13/02/1997 17:32:01.00 PST
2113 | 14/02/1997 17:32:01.00 PST
2114 | 15/02/1997 17:32:01.00 PST
2115 | 16/02/1997 17:32:01.00 PST
2116 | 16/02/0097 17:32 BC
2117 | 16/02/0097 17:32:01.00
2118 | 16/02/0597 17:32:01.00
2119 | 16/02/1097 17:32:01.00
2120 | 16/02/1697 17:32:01.00
2121 | 16/02/1797 17:32:01.00
2122 | 16/02/1897 17:32:01.00
2123 | 16/02/1997 17:32:01.00 PST
2124 | 16/02/2097 17:32:01.00
2125 | 28/02/1996 17:32:01.00 PST
2126 | 29/02/1996 17:32:01.00 PST
2127 | 01/03/1996 17:32:01.00 PST
2128 | 30/12/1996 17:32:01.00 PST
2129 | 31/12/1996 17:32:01.00 PST
2130 | 01/01/1997 17:32:01.00 PST
2131 | 28/02/1997 17:32:01.00 PST
2132 | 01/03/1997 17:32:01.00 PST
2133 | 30/12/1997 17:32:01.00 PST
2134 | 31/12/1997 17:32:01.00 PST
2135 | 31/12/1999 17:32:01.00 PST
2136 | 01/01/2000 17:32:01.00 PST
2137 | 31/12/2000 17:32:01.00 PST
2138 | 01/01/2001 17:32:01.00 PST
2139 | 13/06/1957 00:00:00.00 PDT
2142 SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
2143 eight | european_sql
2144 -------+----------------------------
2145 | 14/01/1973 03:14:21.00 PST
2146 | 01/05/1995 00:30:30.00 PDT
2151 | 10/05/1947 23:59:12.00 PST