4 -- needed so tests pass even in Australia
5 SET australian_timezones = 'off';
6 SET DateStyle = 'Postgres,US';
8 -- Test various input formats
10 SELECT timestamp with time zone '20011227 040506+08';
12 ------------------------------
13 Wed Dec 26 12:05:06 2001 PST
16 SELECT timestamp with time zone '20011227 040506-08';
18 ------------------------------
19 Thu Dec 27 04:05:06 2001 PST
22 SELECT timestamp with time zone '20011227 040506.789+08';
24 ----------------------------------
25 Wed Dec 26 12:05:06.789 2001 PST
28 SELECT timestamp with time zone '20011227 040506.789-08';
30 ----------------------------------
31 Thu Dec 27 04:05:06.789 2001 PST
34 SELECT timestamp with time zone '20011227T040506+08';
36 ------------------------------
37 Wed Dec 26 12:05:06 2001 PST
40 SELECT timestamp with time zone '20011227T040506-08';
42 ------------------------------
43 Thu Dec 27 04:05:06 2001 PST
46 SELECT timestamp with time zone '20011227T040506.789+08';
48 ----------------------------------
49 Wed Dec 26 12:05:06.789 2001 PST
52 SELECT timestamp with time zone '20011227T040506.789-08';
54 ----------------------------------
55 Thu Dec 27 04:05:06.789 2001 PST
58 SELECT timestamp with time zone '2001-12-27 04:05:06.789-08';
60 ----------------------------------
61 Thu Dec 27 04:05:06.789 2001 PST
64 SELECT timestamp with time zone '2001.12.27 04:05:06.789-08';
66 ----------------------------------
67 Thu Dec 27 04:05:06.789 2001 PST
70 SELECT timestamp with time zone '2001/12/27 04:05:06.789-08';
72 ----------------------------------
73 Thu Dec 27 04:05:06.789 2001 PST
76 SELECT timestamp with time zone '12/27/2001 04:05:06.789-08';
78 ----------------------------------
79 Thu Dec 27 04:05:06.789 2001 PST
82 SELECT timestamp with time zone '27/12/2001 04:05:06.789-08';
84 ----------------------------------
85 Thu Dec 27 04:05:06.789 2001 PST
88 SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789+08';
90 ----------------------------------
91 Wed Dec 26 12:05:06.789 2001 PST
94 SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789-08';
96 ----------------------------------
97 Thu Dec 27 04:05:06.789 2001 PST
100 SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789+08';
102 ----------------------------------
103 Wed Dec 26 12:05:06.789 2001 PST
106 SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789-08';
108 ----------------------------------
109 Thu Dec 27 04:05:06.789 2001 PST
112 SELECT timestamp with time zone 'J2452271+08';
114 ------------------------------
115 Wed Dec 26 08:00:00 2001 PST
118 SELECT timestamp with time zone 'J2452271-08';
120 ------------------------------
121 Thu Dec 27 00:00:00 2001 PST
124 SELECT timestamp with time zone 'J2452271.5+08';
126 ------------------------------
127 Wed Dec 26 20:00:00 2001 PST
130 SELECT timestamp with time zone 'J2452271.5-08';
132 ------------------------------
133 Thu Dec 27 12:00:00 2001 PST
136 SELECT timestamp with time zone 'J2452271 04:05:06+08';
138 ------------------------------
139 Wed Dec 26 12:05:06 2001 PST
142 SELECT timestamp with time zone 'J2452271 04:05:06-08';
144 ------------------------------
145 Thu Dec 27 04:05:06 2001 PST
148 SELECT timestamp with time zone 'J2452271T040506+08';
150 ------------------------------
151 Wed Dec 26 12:05:06 2001 PST
154 SELECT timestamp with time zone 'J2452271T040506-08';
156 ------------------------------
157 Thu Dec 27 04:05:06 2001 PST
160 SELECT timestamp with time zone 'J2452271T040506.789+08';
162 ----------------------------------
163 Wed Dec 26 12:05:06.789 2001 PST
166 SELECT timestamp with time zone 'J2452271T040506.789-08';
168 ----------------------------------
169 Thu Dec 27 04:05:06.789 2001 PST
172 -- German/European-style dates with periods as delimiters
173 SELECT timestamp with time zone '27.12.2001 04:05:06.789+08';
175 ----------------------------------
176 Wed Dec 26 12:05:06.789 2001 PST
179 SELECT timestamp with time zone '27.12.2001 04:05:06.789-08';
181 ----------------------------------
182 Thu Dec 27 04:05:06.789 2001 PST
185 SET DateStyle = 'German';
186 SELECT timestamp with time zone '27.12.2001 04:05:06.789+08';
188 -----------------------------
189 26.12.2001 12:05:06.789 PST
192 SELECT timestamp with time zone '27.12.2001 04:05:06.789-08';
194 -----------------------------
195 27.12.2001 04:05:06.789 PST
198 SET DateStyle = 'ISO';
199 -- As of 7.4, allow time without time zone having a time zone specified
200 SELECT time without time zone '040506.789+08';
206 SELECT time without time zone '040506.789-08';
212 SELECT time without time zone 'T040506.789+08';
218 SELECT time without time zone 'T040506.789-08';
224 SELECT time with time zone '040506.789+08';
230 SELECT time with time zone '040506.789-08';
236 SELECT time with time zone 'T040506.789+08';
242 SELECT time with time zone 'T040506.789-08';
248 SELECT time with time zone 'T040506.789 +08';
254 SELECT time with time zone 'T040506.789 -08';
260 SET DateStyle = 'Postgres,US';
262 -- date, time arithmetic
264 SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time";
266 --------------------------
267 Tue Feb 03 04:05:06 1981
270 SELECT date '1991-02-03' + time with time zone '04:05:06 PST' AS "Date + Time PST";
272 ------------------------------
273 Sun Feb 03 04:05:06 1991 PST
276 SELECT date '2001-02-03' + time with time zone '04:05:06 UTC' AS "Date + Time UTC";
278 ------------------------------
279 Fri Feb 02 20:05:06 2001 PST
282 SELECT date '1991-02-03' + interval '2 years' AS "Add Two Years";
284 --------------------------
285 Wed Feb 03 00:00:00 1993
288 SELECT date '2001-12-13' - interval '2 years' AS "Subtract Two Years";
290 --------------------------
291 Mon Dec 13 00:00:00 1999
294 -- subtract time from date should not make sense; use interval instead
295 SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";
297 --------------------------
298 Sat Feb 02 19:54:54 1991
301 SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";
302 ERROR: operator does not exist: date - time with time zone
303 HINT: No operator matches the given name and argument type(s). You may need to add explicit typecasts.
305 -- timestamp, interval arithmetic
307 SELECT timestamp without time zone '1996-03-01' - interval '1 second' AS "Feb 29";
309 --------------------------
310 Thu Feb 29 23:59:59 1996
313 SELECT timestamp without time zone '1999-03-01' - interval '1 second' AS "Feb 28";
315 --------------------------
316 Sun Feb 28 23:59:59 1999
319 SELECT timestamp without time zone '2000-03-01' - interval '1 second' AS "Feb 29";
321 --------------------------
322 Tue Feb 29 23:59:59 2000
325 SELECT timestamp without time zone '1999-12-01' + interval '1 month - 1 second' AS "Dec 31";
327 --------------------------
328 Fri Dec 31 23:59:59 1999
331 SELECT timestamp without time zone 'Jan 1, 4713 BC' + interval '106000000 days' AS "Feb 23, 285506";
333 ----------------------------
334 Fri Feb 23 00:00:00 285506
337 SELECT timestamp without time zone 'Jan 1, 4713 BC' + interval '107000000 days' AS "Jan 20, 288244";
339 ----------------------------
340 Sat Jan 20 00:00:00 288244
343 SELECT timestamp without time zone 'Jan 1, 4713 BC' + interval '109203489 days' AS "Dec 31, 294276";
345 ----------------------------
346 Sun Dec 31 00:00:00 294276
349 SELECT timestamp without time zone '12/31/294276' - timestamp without time zone '12/23/1999' AS "106751991 Days";
356 -- Not directly usable for regression testing since these are not constants.
357 -- So, just try to test parser and hope for the best - thomas 97/04/26
358 SELECT (timestamp without time zone 'today' = (timestamp without time zone 'yesterday' + interval '1 day')) as "True";
364 SELECT (timestamp without time zone 'today' = (timestamp without time zone 'tomorrow' - interval '1 day')) as "True";
370 SELECT (timestamp without time zone 'tomorrow' = (timestamp without time zone 'yesterday' + interval '2 days')) as "True";
376 SELECT (timestamp without time zone 'tomorrow' > 'now') as "True";
382 -- Convert from date and time to timestamp
383 -- This test used to be timestamp(date,time) but no longer allowed by grammar
384 -- to enable support for SQL99 timestamp type syntax.
385 SELECT date '1994-01-01' + time '11:00' AS "Jan_01_1994_11am";
387 --------------------------
388 Sat Jan 01 11:00:00 1994
391 SELECT date '1994-01-01' + time '10:00' AS "Jan_01_1994_10am";
393 --------------------------
394 Sat Jan 01 10:00:00 1994
397 SELECT date '1994-01-01' + timetz '11:00-5' AS "Jan_01_1994_8am";
399 ------------------------------
400 Sat Jan 01 08:00:00 1994 PST
403 SELECT timestamptz(date '1994-01-01', time with time zone '11:00-5') AS "Jan_01_1994_8am";
405 ------------------------------
406 Sat Jan 01 08:00:00 1994 PST
409 SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMP_TBL;
411 ----+-----------------------------
414 | Fri Jan 01 00:00:00 1971
415 | Tue Feb 10 17:32:01 1998
416 | Tue Feb 10 17:32:01 1998
417 | Tue Feb 10 17:32:02 1998
418 | Tue Feb 10 17:32:01.40 1998
419 | Tue Feb 10 17:32:01.50 1998
420 | Tue Feb 10 17:32:01.60 1998
421 | Fri Jan 02 00:00:00 1998
422 | Fri Jan 02 03:04:05 1998
423 | Tue Feb 10 17:32:01 1998
424 | Tue Feb 10 17:32:01 1998
425 | Tue Feb 10 17:32:01 1998
426 | Tue Feb 10 17:32:01 1998
427 | Wed Jun 10 17:32:01 1998
428 | Sun Sep 22 18:19:20 2002
429 | Thu Mar 15 08:14:01 2001
430 | Thu Mar 15 13:14:02 2001
431 | Thu Mar 15 12:14:03 2001
432 | Thu Mar 15 03:14:04 2001
433 | Thu Mar 15 02:14:05 2001
434 | Tue Feb 10 17:32:01 1998
435 | Tue Feb 10 17:32:01 1998
436 | Tue Feb 10 17:32:00 1998
437 | Tue Feb 10 17:32:01 1998
438 | Tue Feb 10 17:32:01 1998
439 | Tue Feb 10 17:32:01 1998
440 | Tue Feb 10 17:32:01 1998
441 | Tue Feb 10 17:32:01 1998
442 | Tue Feb 10 17:32:01 1998
443 | Tue Feb 10 17:32:01 1998
444 | Tue Feb 10 17:32:01 1998
445 | Wed Jun 10 18:32:01 1998
446 | Tue Feb 10 17:32:01 1998
447 | Wed Feb 11 17:32:01 1998
448 | Thu Feb 12 17:32:01 1998
449 | Fri Feb 13 17:32:01 1998
450 | Sat Feb 14 17:32:01 1998
451 | Sun Feb 15 17:32:01 1998
452 | Mon Feb 16 17:32:01 1998
453 | Thu Feb 16 17:32:01 0096 BC
454 | Sun Feb 16 17:32:01 0098
455 | Fri Feb 16 17:32:01 0598
456 | Wed Feb 16 17:32:01 1098
457 | Sun Feb 16 17:32:01 1698
458 | Fri Feb 16 17:32:01 1798
459 | Wed Feb 16 17:32:01 1898
460 | Mon Feb 16 17:32:01 1998
461 | Sun Feb 16 17:32:01 2098
462 | Fri Feb 28 17:32:01 1997
463 | Fri Feb 28 17:32:01 1997
464 | Sat Mar 01 17:32:01 1997
465 | Tue Dec 30 17:32:01 1997
466 | Wed Dec 31 17:32:01 1997
467 | Thu Jan 01 17:32:01 1998
468 | Sat Feb 28 17:32:01 1998
469 | Sun Mar 01 17:32:01 1998
470 | Wed Dec 30 17:32:01 1998
471 | Thu Dec 31 17:32:01 1998
472 | Sun Dec 31 17:32:01 2000
473 | Mon Jan 01 17:32:01 2001
474 | Mon Dec 31 17:32:01 2001
475 | Tue Jan 01 17:32:01 2002
478 SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMP_TBL;
480 ----+-----------------------------
483 | Wed Jan 01 00:00:00 1969
484 | Sat Feb 10 17:32:01 1996
485 | Sat Feb 10 17:32:01 1996
486 | Sat Feb 10 17:32:02 1996
487 | Sat Feb 10 17:32:01.40 1996
488 | Sat Feb 10 17:32:01.50 1996
489 | Sat Feb 10 17:32:01.60 1996
490 | Tue Jan 02 00:00:00 1996
491 | Tue Jan 02 03:04:05 1996
492 | Sat Feb 10 17:32:01 1996
493 | Sat Feb 10 17:32:01 1996
494 | Sat Feb 10 17:32:01 1996
495 | Sat Feb 10 17:32:01 1996
496 | Mon Jun 10 17:32:01 1996
497 | Fri Sep 22 18:19:20 2000
498 | Mon Mar 15 08:14:01 1999
499 | Mon Mar 15 13:14:02 1999
500 | Mon Mar 15 12:14:03 1999
501 | Mon Mar 15 03:14:04 1999
502 | Mon Mar 15 02:14:05 1999
503 | Sat Feb 10 17:32:01 1996
504 | Sat Feb 10 17:32:01 1996
505 | Sat Feb 10 17:32:00 1996
506 | Sat Feb 10 17:32:01 1996
507 | Sat Feb 10 17:32:01 1996
508 | Sat Feb 10 17:32:01 1996
509 | Sat Feb 10 17:32:01 1996
510 | Sat Feb 10 17:32:01 1996
511 | Sat Feb 10 17:32:01 1996
512 | Sat Feb 10 17:32:01 1996
513 | Sat Feb 10 17:32:01 1996
514 | Mon Jun 10 18:32:01 1996
515 | Sat Feb 10 17:32:01 1996
516 | Sun Feb 11 17:32:01 1996
517 | Mon Feb 12 17:32:01 1996
518 | Tue Feb 13 17:32:01 1996
519 | Wed Feb 14 17:32:01 1996
520 | Thu Feb 15 17:32:01 1996
521 | Fri Feb 16 17:32:01 1996
522 | Mon Feb 16 17:32:01 0098 BC
523 | Thu Feb 16 17:32:01 0096
524 | Tue Feb 16 17:32:01 0596
525 | Sun Feb 16 17:32:01 1096
526 | Thu Feb 16 17:32:01 1696
527 | Tue Feb 16 17:32:01 1796
528 | Sun Feb 16 17:32:01 1896
529 | Fri Feb 16 17:32:01 1996
530 | Thu Feb 16 17:32:01 2096
531 | Tue Feb 28 17:32:01 1995
532 | Tue Feb 28 17:32:01 1995
533 | Wed Mar 01 17:32:01 1995
534 | Sat Dec 30 17:32:01 1995
535 | Sun Dec 31 17:32:01 1995
536 | Mon Jan 01 17:32:01 1996
537 | Wed Feb 28 17:32:01 1996
538 | Fri Mar 01 17:32:01 1996
539 | Mon Dec 30 17:32:01 1996
540 | Tue Dec 31 17:32:01 1996
541 | Thu Dec 31 17:32:01 1998
542 | Fri Jan 01 17:32:01 1999
543 | Fri Dec 31 17:32:01 1999
544 | Sat Jan 01 17:32:01 2000
547 SELECT timestamp with time zone '1996-03-01' - interval '1 second' AS "Feb 29";
549 ------------------------------
550 Thu Feb 29 23:59:59 1996 PST
553 SELECT timestamp with time zone '1999-03-01' - interval '1 second' AS "Feb 28";
555 ------------------------------
556 Sun Feb 28 23:59:59 1999 PST
559 SELECT timestamp with time zone '2000-03-01' - interval '1 second' AS "Feb 29";
561 ------------------------------
562 Tue Feb 29 23:59:59 2000 PST
565 SELECT timestamp with time zone '1999-12-01' + interval '1 month - 1 second' AS "Dec 31";
567 ------------------------------
568 Fri Dec 31 23:59:59 1999 PST
571 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
577 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
583 SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
589 SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
595 SELECT timestamptz(date '1994-01-01', time '11:00') AS "Jan_01_1994_10am";
597 ------------------------------
598 Sat Jan 01 11:00:00 1994 PST
601 SELECT timestamptz(date '1994-01-01', time '10:00') AS "Jan_01_1994_9am";
603 ------------------------------
604 Sat Jan 01 10:00:00 1994 PST
607 SELECT timestamptz(date '1994-01-01', time with time zone '11:00-8') AS "Jan_01_1994_11am";
609 ------------------------------
610 Sat Jan 01 11:00:00 1994 PST
613 SELECT timestamptz(date '1994-01-01', time with time zone '10:00-8') AS "Jan_01_1994_10am";
615 ------------------------------
616 Sat Jan 01 10:00:00 1994 PST
619 SELECT timestamptz(date '1994-01-01', time with time zone '11:00-5') AS "Jan_01_1994_8am";
621 ------------------------------
622 Sat Jan 01 08:00:00 1994 PST
625 SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
627 ----+---------------------------------
630 | Thu Dec 31 16:00:00 1970 PST
631 | Tue Feb 10 17:32:01 1998 PST
632 | Tue Feb 10 17:32:01 1998 PST
633 | Tue Feb 10 17:32:02 1998 PST
634 | Tue Feb 10 17:32:01.40 1998 PST
635 | Tue Feb 10 17:32:01.50 1998 PST
636 | Tue Feb 10 17:32:01.60 1998 PST
637 | Fri Jan 02 00:00:00 1998 PST
638 | Fri Jan 02 03:04:05 1998 PST
639 | Tue Feb 10 17:32:01 1998 PST
640 | Tue Feb 10 17:32:01 1998 PST
641 | Tue Feb 10 17:32:01 1998 PST
642 | Tue Feb 10 17:32:01 1998 PST
643 | Wed Jun 10 17:32:01 1998 PDT
644 | Sun Sep 22 18:19:20 2002 PDT
645 | Thu Mar 15 08:14:01 2001 PST
646 | Thu Mar 15 04:14:02 2001 PST
647 | Thu Mar 15 02:14:03 2001 PST
648 | Thu Mar 15 03:14:04 2001 PST
649 | Thu Mar 15 01:14:05 2001 PST
650 | Tue Feb 10 17:32:01 1998 PST
651 | Tue Feb 10 17:32:01 1998 PST
652 | Tue Feb 10 17:32:00 1998 PST
653 | Tue Feb 10 17:32:01 1998 PST
654 | Tue Feb 10 17:32:01 1998 PST
655 | Tue Feb 10 17:32:01 1998 PST
656 | Tue Feb 10 17:32:01 1998 PST
657 | Tue Feb 10 17:32:01 1998 PST
658 | Tue Feb 10 09:32:01 1998 PST
659 | Tue Feb 10 09:32:01 1998 PST
660 | Tue Feb 10 09:32:01 1998 PST
661 | Wed Jun 10 18:32:01 1998 PDT
662 | Tue Feb 10 17:32:01 1998 PST
663 | Wed Feb 11 17:32:01 1998 PST
664 | Thu Feb 12 17:32:01 1998 PST
665 | Fri Feb 13 17:32:01 1998 PST
666 | Sat Feb 14 17:32:01 1998 PST
667 | Sun Feb 15 17:32:01 1998 PST
668 | Mon Feb 16 17:32:01 1998 PST
669 | Thu Feb 16 17:32:01 0096 BC
670 | Sun Feb 16 17:32:01 0098
671 | Fri Feb 16 17:32:01 0598
672 | Wed Feb 16 17:32:01 1098
673 | Sun Feb 16 17:32:01 1698
674 | Fri Feb 16 17:32:01 1798
675 | Wed Feb 16 17:32:01 1898
676 | Mon Feb 16 17:32:01 1998 PST
677 | Sun Feb 16 17:32:01 2098
678 | Fri Feb 28 17:32:01 1997 PST
679 | Fri Feb 28 17:32:01 1997 PST
680 | Sat Mar 01 17:32:01 1997 PST
681 | Tue Dec 30 17:32:01 1997 PST
682 | Wed Dec 31 17:32:01 1997 PST
683 | Thu Jan 01 17:32:01 1998 PST
684 | Sat Feb 28 17:32:01 1998 PST
685 | Sun Mar 01 17:32:01 1998 PST
686 | Wed Dec 30 17:32:01 1998 PST
687 | Thu Dec 31 17:32:01 1998 PST
688 | Sun Dec 31 17:32:01 2000 PST
689 | Mon Jan 01 17:32:01 2001 PST
690 | Mon Dec 31 17:32:01 2001 PST
691 | Tue Jan 01 17:32:01 2002 PST
694 SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
696 ----+---------------------------------
699 | Tue Dec 31 16:00:00 1968 PST
700 | Sat Feb 10 17:32:01 1996 PST
701 | Sat Feb 10 17:32:01 1996 PST
702 | Sat Feb 10 17:32:02 1996 PST
703 | Sat Feb 10 17:32:01.40 1996 PST
704 | Sat Feb 10 17:32:01.50 1996 PST
705 | Sat Feb 10 17:32:01.60 1996 PST
706 | Tue Jan 02 00:00:00 1996 PST
707 | Tue Jan 02 03:04:05 1996 PST
708 | Sat Feb 10 17:32:01 1996 PST
709 | Sat Feb 10 17:32:01 1996 PST
710 | Sat Feb 10 17:32:01 1996 PST
711 | Sat Feb 10 17:32:01 1996 PST
712 | Mon Jun 10 17:32:01 1996 PDT
713 | Fri Sep 22 18:19:20 2000 PDT
714 | Mon Mar 15 08:14:01 1999 PST
715 | Mon Mar 15 04:14:02 1999 PST
716 | Mon Mar 15 02:14:03 1999 PST
717 | Mon Mar 15 03:14:04 1999 PST
718 | Mon Mar 15 01:14:05 1999 PST
719 | Sat Feb 10 17:32:01 1996 PST
720 | Sat Feb 10 17:32:01 1996 PST
721 | Sat Feb 10 17:32:00 1996 PST
722 | Sat Feb 10 17:32:01 1996 PST
723 | Sat Feb 10 17:32:01 1996 PST
724 | Sat Feb 10 17:32:01 1996 PST
725 | Sat Feb 10 17:32:01 1996 PST
726 | Sat Feb 10 17:32:01 1996 PST
727 | Sat Feb 10 09:32:01 1996 PST
728 | Sat Feb 10 09:32:01 1996 PST
729 | Sat Feb 10 09:32:01 1996 PST
730 | Mon Jun 10 18:32:01 1996 PDT
731 | Sat Feb 10 17:32:01 1996 PST
732 | Sun Feb 11 17:32:01 1996 PST
733 | Mon Feb 12 17:32:01 1996 PST
734 | Tue Feb 13 17:32:01 1996 PST
735 | Wed Feb 14 17:32:01 1996 PST
736 | Thu Feb 15 17:32:01 1996 PST
737 | Fri Feb 16 17:32:01 1996 PST
738 | Mon Feb 16 17:32:01 0098 BC
739 | Thu Feb 16 17:32:01 0096
740 | Tue Feb 16 17:32:01 0596
741 | Sun Feb 16 17:32:01 1096
742 | Thu Feb 16 17:32:01 1696
743 | Tue Feb 16 17:32:01 1796
744 | Sun Feb 16 17:32:01 1896
745 | Fri Feb 16 17:32:01 1996 PST
746 | Thu Feb 16 17:32:01 2096
747 | Tue Feb 28 17:32:01 1995 PST
748 | Tue Feb 28 17:32:01 1995 PST
749 | Wed Mar 01 17:32:01 1995 PST
750 | Sat Dec 30 17:32:01 1995 PST
751 | Sun Dec 31 17:32:01 1995 PST
752 | Mon Jan 01 17:32:01 1996 PST
753 | Wed Feb 28 17:32:01 1996 PST
754 | Fri Mar 01 17:32:01 1996 PST
755 | Mon Dec 30 17:32:01 1996 PST
756 | Tue Dec 31 17:32:01 1996 PST
757 | Thu Dec 31 17:32:01 1998 PST
758 | Fri Jan 01 17:32:01 1999 PST
759 | Fri Dec 31 17:32:01 1999 PST
760 | Sat Jan 01 17:32:01 2000 PST
764 -- time, interval arithmetic
766 SELECT CAST(time '01:02' AS interval) AS "+01:02";
772 SELECT CAST(interval '02:03' AS time) AS "02:03:00";
778 SELECT time '01:30' + interval '02:01' AS "03:31:00";
784 SELECT time '01:30' - interval '02:01' AS "23:29:00";
790 SELECT time '02:30' + interval '36:01' AS "14:31:00";
796 SELECT time '03:30' + interval '1 month 04:01' AS "07:31:00";
802 SELECT interval '04:30' - time '01:02' AS "20:32:00";
808 SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01";
809 ERROR: Cannot cast type time with time zone to interval
810 SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08";
811 ERROR: Cannot cast type interval to time with time zone
812 SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";
818 SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08";
824 -- These two tests cannot be used because they default to current timezone,
825 -- which may be either -08 or -07 depending on the time of year.
826 -- SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";
827 -- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08";
828 -- Try the following two tests instead, as a poor substitute
829 SELECT CAST(CAST(date 'today' + time with time zone '01:30'
830 + interval '02:01' AS time with time zone) AS time) AS "03:31:00";
836 SELECT CAST(cast(date 'today' + time with time zone '03:30'
837 + interval '1 month 04:01' as timestamp without time zone) AS time) AS "07:31:00";
843 SELECT interval '04:30' - time with time zone '01:02-05' AS "20:32:00-05";
849 SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
850 WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
851 AND i.f1 BETWEEN '00:00' AND '23:00';
853 -----------------------------
854 Mon Feb 10 17:33:01 1997
855 Mon Feb 10 22:32:01 1997
856 Mon Feb 10 17:33:01 1997
857 Mon Feb 10 22:32:01 1997
858 Mon Feb 10 17:33:02 1997
859 Mon Feb 10 22:32:02 1997
860 Mon Feb 10 17:33:01.40 1997
861 Mon Feb 10 22:32:01.40 1997
862 Mon Feb 10 17:33:01.50 1997
863 Mon Feb 10 22:32:01.50 1997
864 Mon Feb 10 17:33:01.60 1997
865 Mon Feb 10 22:32:01.60 1997
866 Thu Jan 02 00:01:00 1997
867 Thu Jan 02 05:00:00 1997
868 Thu Jan 02 03:05:05 1997
869 Thu Jan 02 08:04:05 1997
870 Mon Feb 10 17:33:01 1997
871 Mon Feb 10 22:32:01 1997
872 Mon Feb 10 17:33:01 1997
873 Mon Feb 10 22:32:01 1997
874 Mon Feb 10 17:33:01 1997
875 Mon Feb 10 22:32:01 1997
876 Mon Feb 10 17:33:01 1997
877 Mon Feb 10 22:32:01 1997
878 Tue Jun 10 17:33:01 1997
879 Tue Jun 10 22:32:01 1997
880 Wed Mar 15 08:15:01 2000
881 Wed Mar 15 13:14:01 2000
882 Wed Mar 15 13:15:02 2000
883 Wed Mar 15 18:14:02 2000
884 Wed Mar 15 12:15:03 2000
885 Wed Mar 15 17:14:03 2000
886 Wed Mar 15 03:15:04 2000
887 Wed Mar 15 08:14:04 2000
888 Wed Mar 15 02:15:05 2000
889 Wed Mar 15 07:14:05 2000
890 Mon Feb 10 17:33:01 1997
891 Mon Feb 10 22:32:01 1997
892 Mon Feb 10 17:33:01 1997
893 Mon Feb 10 22:32:01 1997
894 Mon Feb 10 17:33:00 1997
895 Mon Feb 10 22:32:00 1997
896 Mon Feb 10 17:33:01 1997
897 Mon Feb 10 22:32:01 1997
898 Mon Feb 10 17:33:01 1997
899 Mon Feb 10 22:32:01 1997
900 Mon Feb 10 17:33:01 1997
901 Mon Feb 10 22:32:01 1997
902 Mon Feb 10 17:33:01 1997
903 Mon Feb 10 22:32:01 1997
904 Mon Feb 10 17:33:01 1997
905 Mon Feb 10 22:32:01 1997
906 Mon Feb 10 17:33:01 1997
907 Mon Feb 10 22:32:01 1997
908 Mon Feb 10 17:33:01 1997
909 Mon Feb 10 22:32:01 1997
910 Mon Feb 10 17:33:01 1997
911 Mon Feb 10 22:32:01 1997
912 Tue Jun 10 18:33:01 1997
913 Tue Jun 10 23:32:01 1997
914 Mon Feb 10 17:33:01 1997
915 Mon Feb 10 22:32:01 1997
916 Tue Feb 11 17:33:01 1997
917 Tue Feb 11 22:32:01 1997
918 Wed Feb 12 17:33:01 1997
919 Wed Feb 12 22:32:01 1997
920 Thu Feb 13 17:33:01 1997
921 Thu Feb 13 22:32:01 1997
922 Fri Feb 14 17:33:01 1997
923 Fri Feb 14 22:32:01 1997
924 Sat Feb 15 17:33:01 1997
925 Sat Feb 15 22:32:01 1997
926 Sun Feb 16 17:33:01 1997
927 Sun Feb 16 22:32:01 1997
928 Sun Feb 16 17:33:01 1997
929 Sun Feb 16 22:32:01 1997
930 Wed Feb 28 17:33:01 1996
931 Wed Feb 28 22:32:01 1996
932 Thu Feb 29 17:33:01 1996
933 Thu Feb 29 22:32:01 1996
934 Fri Mar 01 17:33:01 1996
935 Fri Mar 01 22:32:01 1996
936 Mon Dec 30 17:33:01 1996
937 Mon Dec 30 22:32:01 1996
938 Tue Dec 31 17:33:01 1996
939 Tue Dec 31 22:32:01 1996
940 Wed Jan 01 17:33:01 1997
941 Wed Jan 01 22:32:01 1997
942 Fri Feb 28 17:33:01 1997
943 Fri Feb 28 22:32:01 1997
944 Sat Mar 01 17:33:01 1997
945 Sat Mar 01 22:32:01 1997
946 Tue Dec 30 17:33:01 1997
947 Tue Dec 30 22:32:01 1997
948 Wed Dec 31 17:33:01 1997
949 Wed Dec 31 22:32:01 1997
950 Fri Dec 31 17:33:01 1999
951 Fri Dec 31 22:32:01 1999
952 Sat Jan 01 17:33:01 2000
953 Sat Jan 01 22:32:01 2000
954 Sun Dec 31 17:33:01 2000
955 Sun Dec 31 22:32:01 2000
958 SELECT t.d1 - i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
959 WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
960 AND i.f1 BETWEEN '00:00' AND '23:00';
962 -----------------------------
963 Mon Feb 10 17:31:01 1997
964 Mon Feb 10 12:32:01 1997
965 Mon Feb 10 17:31:01 1997
966 Mon Feb 10 12:32:01 1997
967 Mon Feb 10 17:31:02 1997
968 Mon Feb 10 12:32:02 1997
969 Mon Feb 10 17:31:01.40 1997
970 Mon Feb 10 12:32:01.40 1997
971 Mon Feb 10 17:31:01.50 1997
972 Mon Feb 10 12:32:01.50 1997
973 Mon Feb 10 17:31:01.60 1997
974 Mon Feb 10 12:32:01.60 1997
975 Wed Jan 01 23:59:00 1997
976 Wed Jan 01 19:00:00 1997
977 Thu Jan 02 03:03:05 1997
978 Wed Jan 01 22:04:05 1997
979 Mon Feb 10 17:31:01 1997
980 Mon Feb 10 12:32:01 1997
981 Mon Feb 10 17:31:01 1997
982 Mon Feb 10 12:32:01 1997
983 Mon Feb 10 17:31:01 1997
984 Mon Feb 10 12:32:01 1997
985 Mon Feb 10 17:31:01 1997
986 Mon Feb 10 12:32:01 1997
987 Tue Jun 10 17:31:01 1997
988 Tue Jun 10 12:32:01 1997
989 Wed Mar 15 08:13:01 2000
990 Wed Mar 15 03:14:01 2000
991 Wed Mar 15 13:13:02 2000
992 Wed Mar 15 08:14:02 2000
993 Wed Mar 15 12:13:03 2000
994 Wed Mar 15 07:14:03 2000
995 Wed Mar 15 03:13:04 2000
996 Tue Mar 14 22:14:04 2000
997 Wed Mar 15 02:13:05 2000
998 Tue Mar 14 21:14:05 2000
999 Mon Feb 10 17:31:01 1997
1000 Mon Feb 10 12:32:01 1997
1001 Mon Feb 10 17:31:01 1997
1002 Mon Feb 10 12:32:01 1997
1003 Mon Feb 10 17:31:00 1997
1004 Mon Feb 10 12:32:00 1997
1005 Mon Feb 10 17:31:01 1997
1006 Mon Feb 10 12:32:01 1997
1007 Mon Feb 10 17:31:01 1997
1008 Mon Feb 10 12:32:01 1997
1009 Mon Feb 10 17:31:01 1997
1010 Mon Feb 10 12:32:01 1997
1011 Mon Feb 10 17:31:01 1997
1012 Mon Feb 10 12:32:01 1997
1013 Mon Feb 10 17:31:01 1997
1014 Mon Feb 10 12:32:01 1997
1015 Mon Feb 10 17:31:01 1997
1016 Mon Feb 10 12:32:01 1997
1017 Mon Feb 10 17:31:01 1997
1018 Mon Feb 10 12:32:01 1997
1019 Mon Feb 10 17:31:01 1997
1020 Mon Feb 10 12:32:01 1997
1021 Tue Jun 10 18:31:01 1997
1022 Tue Jun 10 13:32:01 1997
1023 Mon Feb 10 17:31:01 1997
1024 Mon Feb 10 12:32:01 1997
1025 Tue Feb 11 17:31:01 1997
1026 Tue Feb 11 12:32:01 1997
1027 Wed Feb 12 17:31:01 1997
1028 Wed Feb 12 12:32:01 1997
1029 Thu Feb 13 17:31:01 1997
1030 Thu Feb 13 12:32:01 1997
1031 Fri Feb 14 17:31:01 1997
1032 Fri Feb 14 12:32:01 1997
1033 Sat Feb 15 17:31:01 1997
1034 Sat Feb 15 12:32:01 1997
1035 Sun Feb 16 17:31:01 1997
1036 Sun Feb 16 12:32:01 1997
1037 Sun Feb 16 17:31:01 1997
1038 Sun Feb 16 12:32:01 1997
1039 Wed Feb 28 17:31:01 1996
1040 Wed Feb 28 12:32:01 1996
1041 Thu Feb 29 17:31:01 1996
1042 Thu Feb 29 12:32:01 1996
1043 Fri Mar 01 17:31:01 1996
1044 Fri Mar 01 12:32:01 1996
1045 Mon Dec 30 17:31:01 1996
1046 Mon Dec 30 12:32:01 1996
1047 Tue Dec 31 17:31:01 1996
1048 Tue Dec 31 12:32:01 1996
1049 Wed Jan 01 17:31:01 1997
1050 Wed Jan 01 12:32:01 1997
1051 Fri Feb 28 17:31:01 1997
1052 Fri Feb 28 12:32:01 1997
1053 Sat Mar 01 17:31:01 1997
1054 Sat Mar 01 12:32:01 1997
1055 Tue Dec 30 17:31:01 1997
1056 Tue Dec 30 12:32:01 1997
1057 Wed Dec 31 17:31:01 1997
1058 Wed Dec 31 12:32:01 1997
1059 Fri Dec 31 17:31:01 1999
1060 Fri Dec 31 12:32:01 1999
1061 Sat Jan 01 17:31:01 2000
1062 Sat Jan 01 12:32:01 2000
1063 Sun Dec 31 17:31:01 2000
1064 Sun Dec 31 12:32:01 2000
1067 SELECT t.f1 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
1152 SELECT t.f1 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
1237 SELECT t.f1 + i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
1342 SELECT t.f1 - i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
1447 -- SQL9x OVERLAPS operator
1448 -- test with time zone
1449 SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28')
1450 OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "True";
1456 SELECT (timestamp with time zone '2000-11-26', timestamp with time zone '2000-11-27')
1457 OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "False";
1463 SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28')
1464 OVERLAPS (timestamp with time zone '2000-11-27 12:00', interval '1 day') AS "True";
1470 SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
1471 OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "False";
1477 SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
1478 OVERLAPS (timestamp with time zone '2000-11-27', interval '12 hours') AS "True";
1484 SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
1485 OVERLAPS (timestamp with time zone '2000-11-27 12:00', interval '12 hours') AS "False";
1491 -- test without time zone
1492 SELECT (timestamp without time zone '2000-11-27', timestamp without time zone '2000-11-28')
1493 OVERLAPS (timestamp without time zone '2000-11-27 12:00', timestamp without time zone '2000-11-30') AS "True";
1499 SELECT (timestamp without time zone '2000-11-26', timestamp without time zone '2000-11-27')
1500 OVERLAPS (timestamp without time zone '2000-11-27 12:00', timestamp without time zone '2000-11-30') AS "False";
1506 SELECT (timestamp without time zone '2000-11-27', timestamp without time zone '2000-11-28')
1507 OVERLAPS (timestamp without time zone '2000-11-27 12:00', interval '1 day') AS "True";
1513 SELECT (timestamp without time zone '2000-11-27', interval '12 hours')
1514 OVERLAPS (timestamp without time zone '2000-11-27 12:00', timestamp without time zone '2000-11-30') AS "False";
1520 SELECT (timestamp without time zone '2000-11-27', interval '12 hours')
1521 OVERLAPS (timestamp without time zone '2000-11-27', interval '12 hours') AS "True";
1527 SELECT (timestamp without time zone '2000-11-27', interval '12 hours')
1528 OVERLAPS (timestamp without time zone '2000-11-27 12:00', interval '12 hours') AS "False";
1534 -- test time and interval
1535 SELECT (time '00:00', time '01:00')
1536 OVERLAPS (time '00:30', time '01:30') AS "True";
1542 SELECT (time '00:00', interval '1 hour')
1543 OVERLAPS (time '00:30', interval '1 hour') AS "True";
1549 SELECT (time '00:00', interval '1 hour')
1550 OVERLAPS (time '01:30', interval '1 hour') AS "False";
1556 -- SQL99 seems to want this to be false (and we conform to the spec).
1557 -- istm that this *should* return true, on the theory that time
1558 -- intervals can wrap around the day boundary - thomas 2001-09-25
1559 SELECT (time '00:00', interval '1 hour')
1560 OVERLAPS (time '01:30', interval '1 day') AS "False";
1566 CREATE TABLE TEMP_TIMESTAMP (f1 timestamp with time zone);
1567 -- get some candidate input values
1568 INSERT INTO TEMP_TIMESTAMP (f1)
1569 SELECT d1 FROM TIMESTAMP_TBL
1570 WHERE d1 BETWEEN '13-jun-1957' AND '1-jan-1997'
1571 OR d1 BETWEEN '1-jan-1999' AND '1-jan-2010';
1572 SELECT '' AS "16", f1 AS "timestamp"
1574 ORDER BY "timestamp";
1576 ----+------------------------------
1577 | Thu Jan 01 00:00:00 1970 PST
1578 | Wed Feb 28 17:32:01 1996 PST
1579 | Thu Feb 29 17:32:01 1996 PST
1580 | Fri Mar 01 17:32:01 1996 PST
1581 | Mon Dec 30 17:32:01 1996 PST
1582 | Tue Dec 31 17:32:01 1996 PST
1583 | Fri Dec 31 17:32:01 1999 PST
1584 | Sat Jan 01 17:32:01 2000 PST
1585 | Wed Mar 15 02:14:05 2000 PST
1586 | Wed Mar 15 03:14:04 2000 PST
1587 | Wed Mar 15 08:14:01 2000 PST
1588 | Wed Mar 15 12:14:03 2000 PST
1589 | Wed Mar 15 13:14:02 2000 PST
1590 | Sun Dec 31 17:32:01 2000 PST
1591 | Mon Jan 01 17:32:01 2001 PST
1592 | Sat Sep 22 18:19:20 2001 PDT
1595 SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 + t.f1 AS plus
1596 FROM TEMP_TIMESTAMP d, INTERVAL_TBL t
1597 ORDER BY plus, "timestamp", "interval";
1598 160 | timestamp | interval | plus
1599 -----+------------------------------+-------------------------------+------------------------------
1600 | Thu Jan 01 00:00:00 1970 PST | @ 14 secs ago | Wed Dec 31 23:59:46 1969 PST
1601 | Thu Jan 01 00:00:00 1970 PST | @ 1 min | Thu Jan 01 00:01:00 1970 PST
1602 | Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Thu Jan 01 05:00:00 1970 PST
1603 | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Jan 02 02:03:04 1970 PST
1604 | Thu Jan 01 00:00:00 1970 PST | @ 10 days | Sun Jan 11 00:00:00 1970 PST
1605 | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Apr 01 00:00:00 1970 PST
1606 | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Mon Jun 01 00:00:00 1970 PDT
1607 | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Mon Jun 01 12:00:00 1970 PDT
1608 | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Thu Jan 01 00:00:00 1976 PST
1609 | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago | Wed Feb 28 17:31:47 1996 PST
1610 | Wed Feb 28 17:32:01 1996 PST | @ 1 min | Wed Feb 28 17:33:01 1996 PST
1611 | Wed Feb 28 17:32:01 1996 PST | @ 5 hours | Wed Feb 28 22:32:01 1996 PST
1612 | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago | Thu Feb 29 17:31:47 1996 PST
1613 | Thu Feb 29 17:32:01 1996 PST | @ 1 min | Thu Feb 29 17:33:01 1996 PST
1614 | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 19:35:05 1996 PST
1615 | Thu Feb 29 17:32:01 1996 PST | @ 5 hours | Thu Feb 29 22:32:01 1996 PST
1616 | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago | Fri Mar 01 17:31:47 1996 PST
1617 | Fri Mar 01 17:32:01 1996 PST | @ 1 min | Fri Mar 01 17:33:01 1996 PST
1618 | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Mar 01 19:35:05 1996 PST
1619 | Fri Mar 01 17:32:01 1996 PST | @ 5 hours | Fri Mar 01 22:32:01 1996 PST
1620 | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Mar 02 19:35:05 1996 PST
1621 | Wed Feb 28 17:32:01 1996 PST | @ 10 days | Sat Mar 09 17:32:01 1996 PST
1622 | Thu Feb 29 17:32:01 1996 PST | @ 10 days | Sun Mar 10 17:32:01 1996 PST
1623 | Fri Mar 01 17:32:01 1996 PST | @ 10 days | Mon Mar 11 17:32:01 1996 PST
1624 | Wed Feb 28 17:32:01 1996 PST | @ 3 mons | Tue May 28 17:32:01 1996 PDT
1625 | Thu Feb 29 17:32:01 1996 PST | @ 3 mons | Wed May 29 17:32:01 1996 PDT
1626 | Fri Mar 01 17:32:01 1996 PST | @ 3 mons | Sat Jun 01 17:32:01 1996 PDT
1627 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons | Sun Jul 28 17:32:01 1996 PDT
1628 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours | Mon Jul 29 05:32:01 1996 PDT
1629 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons | Mon Jul 29 17:32:01 1996 PDT
1630 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours | Tue Jul 30 05:32:01 1996 PDT
1631 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons | Thu Aug 01 17:32:01 1996 PDT
1632 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours | Fri Aug 02 05:32:01 1996 PDT
1633 | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago | Mon Dec 30 17:31:47 1996 PST
1634 | Mon Dec 30 17:32:01 1996 PST | @ 1 min | Mon Dec 30 17:33:01 1996 PST
1635 | Mon Dec 30 17:32:01 1996 PST | @ 5 hours | Mon Dec 30 22:32:01 1996 PST
1636 | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago | Tue Dec 31 17:31:47 1996 PST
1637 | Tue Dec 31 17:32:01 1996 PST | @ 1 min | Tue Dec 31 17:33:01 1996 PST
1638 | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 31 19:35:05 1996 PST
1639 | Tue Dec 31 17:32:01 1996 PST | @ 5 hours | Tue Dec 31 22:32:01 1996 PST
1640 | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Jan 01 19:35:05 1997 PST
1641 | Mon Dec 30 17:32:01 1996 PST | @ 10 days | Thu Jan 09 17:32:01 1997 PST
1642 | Tue Dec 31 17:32:01 1996 PST | @ 10 days | Fri Jan 10 17:32:01 1997 PST
1643 | Mon Dec 30 17:32:01 1996 PST | @ 3 mons | Sun Mar 30 17:32:01 1997 PST
1644 | Tue Dec 31 17:32:01 1996 PST | @ 3 mons | Mon Mar 31 17:32:01 1997 PST
1645 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons | Fri May 30 17:32:01 1997 PDT
1646 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours | Sat May 31 05:32:01 1997 PDT
1647 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons | Sat May 31 17:32:01 1997 PDT
1648 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours | Sun Jun 01 05:32:01 1997 PDT
1649 | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago | Fri Dec 31 17:31:47 1999 PST
1650 | Fri Dec 31 17:32:01 1999 PST | @ 1 min | Fri Dec 31 17:33:01 1999 PST
1651 | Fri Dec 31 17:32:01 1999 PST | @ 5 hours | Fri Dec 31 22:32:01 1999 PST
1652 | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago | Sat Jan 01 17:31:47 2000 PST
1653 | Sat Jan 01 17:32:01 2000 PST | @ 1 min | Sat Jan 01 17:33:01 2000 PST
1654 | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Jan 01 19:35:05 2000 PST
1655 | Sat Jan 01 17:32:01 2000 PST | @ 5 hours | Sat Jan 01 22:32:01 2000 PST
1656 | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Jan 02 19:35:05 2000 PST
1657 | Fri Dec 31 17:32:01 1999 PST | @ 10 days | Mon Jan 10 17:32:01 2000 PST
1658 | Sat Jan 01 17:32:01 2000 PST | @ 10 days | Tue Jan 11 17:32:01 2000 PST
1659 | Wed Mar 15 02:14:05 2000 PST | @ 14 secs ago | Wed Mar 15 02:13:51 2000 PST
1660 | Wed Mar 15 02:14:05 2000 PST | @ 1 min | Wed Mar 15 02:15:05 2000 PST
1661 | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago | Wed Mar 15 03:13:50 2000 PST
1662 | Wed Mar 15 03:14:04 2000 PST | @ 1 min | Wed Mar 15 03:15:04 2000 PST
1663 | Wed Mar 15 02:14:05 2000 PST | @ 5 hours | Wed Mar 15 07:14:05 2000 PST
1664 | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago | Wed Mar 15 08:13:47 2000 PST
1665 | Wed Mar 15 03:14:04 2000 PST | @ 5 hours | Wed Mar 15 08:14:04 2000 PST
1666 | Wed Mar 15 08:14:01 2000 PST | @ 1 min | Wed Mar 15 08:15:01 2000 PST
1667 | Wed Mar 15 12:14:03 2000 PST | @ 14 secs ago | Wed Mar 15 12:13:49 2000 PST
1668 | Wed Mar 15 12:14:03 2000 PST | @ 1 min | Wed Mar 15 12:15:03 2000 PST
1669 | Wed Mar 15 13:14:02 2000 PST | @ 14 secs ago | Wed Mar 15 13:13:48 2000 PST
1670 | Wed Mar 15 08:14:01 2000 PST | @ 5 hours | Wed Mar 15 13:14:01 2000 PST
1671 | Wed Mar 15 13:14:02 2000 PST | @ 1 min | Wed Mar 15 13:15:02 2000 PST
1672 | Wed Mar 15 12:14:03 2000 PST | @ 5 hours | Wed Mar 15 17:14:03 2000 PST
1673 | Wed Mar 15 13:14:02 2000 PST | @ 5 hours | Wed Mar 15 18:14:02 2000 PST
1674 | Wed Mar 15 02:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 04:17:09 2000 PST
1675 | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 05:17:08 2000 PST
1676 | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 10:17:05 2000 PST
1677 | Wed Mar 15 12:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 14:17:07 2000 PST
1678 | Wed Mar 15 13:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 15:17:06 2000 PST
1679 | Wed Mar 15 02:14:05 2000 PST | @ 10 days | Sat Mar 25 02:14:05 2000 PST
1680 | Wed Mar 15 03:14:04 2000 PST | @ 10 days | Sat Mar 25 03:14:04 2000 PST
1681 | Wed Mar 15 08:14:01 2000 PST | @ 10 days | Sat Mar 25 08:14:01 2000 PST
1682 | Wed Mar 15 12:14:03 2000 PST | @ 10 days | Sat Mar 25 12:14:03 2000 PST
1683 | Wed Mar 15 13:14:02 2000 PST | @ 10 days | Sat Mar 25 13:14:02 2000 PST
1684 | Fri Dec 31 17:32:01 1999 PST | @ 3 mons | Fri Mar 31 17:32:01 2000 PST
1685 | Sat Jan 01 17:32:01 2000 PST | @ 3 mons | Sat Apr 01 17:32:01 2000 PST
1686 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons | Wed May 31 17:32:01 2000 PDT
1687 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours | Thu Jun 01 05:32:01 2000 PDT
1688 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons | Thu Jun 01 17:32:01 2000 PDT
1689 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours | Fri Jun 02 05:32:01 2000 PDT
1690 | Wed Mar 15 02:14:05 2000 PST | @ 3 mons | Thu Jun 15 02:14:05 2000 PDT
1691 | Wed Mar 15 03:14:04 2000 PST | @ 3 mons | Thu Jun 15 03:14:04 2000 PDT
1692 | Wed Mar 15 08:14:01 2000 PST | @ 3 mons | Thu Jun 15 08:14:01 2000 PDT
1693 | Wed Mar 15 12:14:03 2000 PST | @ 3 mons | Thu Jun 15 12:14:03 2000 PDT
1694 | Wed Mar 15 13:14:02 2000 PST | @ 3 mons | Thu Jun 15 13:14:02 2000 PDT
1695 | Wed Mar 15 02:14:05 2000 PST | @ 5 mons | Tue Aug 15 02:14:05 2000 PDT
1696 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons | Tue Aug 15 03:14:04 2000 PDT
1697 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons | Tue Aug 15 08:14:01 2000 PDT
1698 | Wed Mar 15 12:14:03 2000 PST | @ 5 mons | Tue Aug 15 12:14:03 2000 PDT
1699 | Wed Mar 15 13:14:02 2000 PST | @ 5 mons | Tue Aug 15 13:14:02 2000 PDT
1700 | Wed Mar 15 02:14:05 2000 PST | @ 5 mons 12 hours | Tue Aug 15 14:14:05 2000 PDT
1701 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours | Tue Aug 15 15:14:04 2000 PDT
1702 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours | Tue Aug 15 20:14:01 2000 PDT
1703 | Wed Mar 15 12:14:03 2000 PST | @ 5 mons 12 hours | Wed Aug 16 00:14:03 2000 PDT
1704 | Wed Mar 15 13:14:02 2000 PST | @ 5 mons 12 hours | Wed Aug 16 01:14:02 2000 PDT
1705 | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago | Sun Dec 31 17:31:47 2000 PST
1706 | Sun Dec 31 17:32:01 2000 PST | @ 1 min | Sun Dec 31 17:33:01 2000 PST
1707 | Sun Dec 31 17:32:01 2000 PST | @ 5 hours | Sun Dec 31 22:32:01 2000 PST
1708 | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago | Mon Jan 01 17:31:47 2001 PST
1709 | Mon Jan 01 17:32:01 2001 PST | @ 1 min | Mon Jan 01 17:33:01 2001 PST
1710 | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Jan 01 19:35:05 2001 PST
1711 | Mon Jan 01 17:32:01 2001 PST | @ 5 hours | Mon Jan 01 22:32:01 2001 PST
1712 | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Jan 02 19:35:05 2001 PST
1713 | Sun Dec 31 17:32:01 2000 PST | @ 10 days | Wed Jan 10 17:32:01 2001 PST
1714 | Mon Jan 01 17:32:01 2001 PST | @ 10 days | Thu Jan 11 17:32:01 2001 PST
1715 | Sun Dec 31 17:32:01 2000 PST | @ 3 mons | Sat Mar 31 17:32:01 2001 PST
1716 | Mon Jan 01 17:32:01 2001 PST | @ 3 mons | Sun Apr 01 17:32:01 2001 PDT
1717 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons | Thu May 31 17:32:01 2001 PDT
1718 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours | Fri Jun 01 05:32:01 2001 PDT
1719 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons | Fri Jun 01 17:32:01 2001 PDT
1720 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours | Sat Jun 02 05:32:01 2001 PDT
1721 | Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago | Sat Sep 22 18:19:06 2001 PDT
1722 | Sat Sep 22 18:19:20 2001 PDT | @ 1 min | Sat Sep 22 18:20:20 2001 PDT
1723 | Sat Sep 22 18:19:20 2001 PDT | @ 5 hours | Sat Sep 22 23:19:20 2001 PDT
1724 | Sat Sep 22 18:19:20 2001 PDT | @ 1 day 2 hours 3 mins 4 secs | Sun Sep 23 20:22:24 2001 PDT
1725 | Sat Sep 22 18:19:20 2001 PDT | @ 10 days | Tue Oct 02 18:19:20 2001 PDT
1726 | Sat Sep 22 18:19:20 2001 PDT | @ 3 mons | Sat Dec 22 18:19:20 2001 PST
1727 | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons | Fri Feb 22 18:19:20 2002 PST
1728 | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons 12 hours | Sat Feb 23 06:19:20 2002 PST
1729 | Wed Feb 28 17:32:01 1996 PST | @ 6 years | Thu Feb 28 17:32:01 2002 PST
1730 | Thu Feb 29 17:32:01 1996 PST | @ 6 years | Thu Feb 28 17:32:01 2002 PST
1731 | Fri Mar 01 17:32:01 1996 PST | @ 6 years | Fri Mar 01 17:32:01 2002 PST
1732 | Mon Dec 30 17:32:01 1996 PST | @ 6 years | Mon Dec 30 17:32:01 2002 PST
1733 | Tue Dec 31 17:32:01 1996 PST | @ 6 years | Tue Dec 31 17:32:01 2002 PST
1734 | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Thu Jan 01 00:00:00 2004 PST
1735 | Fri Dec 31 17:32:01 1999 PST | @ 6 years | Sat Dec 31 17:32:01 2005 PST
1736 | Sat Jan 01 17:32:01 2000 PST | @ 6 years | Sun Jan 01 17:32:01 2006 PST
1737 | Wed Mar 15 02:14:05 2000 PST | @ 6 years | Wed Mar 15 02:14:05 2006 PST
1738 | Wed Mar 15 03:14:04 2000 PST | @ 6 years | Wed Mar 15 03:14:04 2006 PST
1739 | Wed Mar 15 08:14:01 2000 PST | @ 6 years | Wed Mar 15 08:14:01 2006 PST
1740 | Wed Mar 15 12:14:03 2000 PST | @ 6 years | Wed Mar 15 12:14:03 2006 PST
1741 | Wed Mar 15 13:14:02 2000 PST | @ 6 years | Wed Mar 15 13:14:02 2006 PST
1742 | Sun Dec 31 17:32:01 2000 PST | @ 6 years | Sun Dec 31 17:32:01 2006 PST
1743 | Mon Jan 01 17:32:01 2001 PST | @ 6 years | Mon Jan 01 17:32:01 2007 PST
1744 | Sat Sep 22 18:19:20 2001 PDT | @ 6 years | Sat Sep 22 18:19:20 2007 PDT
1745 | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Thu Feb 28 17:32:01 2030 PST
1746 | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Thu Feb 28 17:32:01 2030 PST
1747 | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Fri Mar 01 17:32:01 2030 PST
1748 | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Mon Dec 30 17:32:01 2030 PST
1749 | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Tue Dec 31 17:32:01 2030 PST
1750 | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Sat Dec 31 17:32:01 2033 PST
1751 | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sun Jan 01 17:32:01 2034 PST
1752 | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Wed Mar 15 02:14:05 2034 PST
1753 | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Wed Mar 15 03:14:04 2034 PST
1754 | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Wed Mar 15 08:14:01 2034 PST
1755 | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Wed Mar 15 12:14:03 2034 PST
1756 | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Wed Mar 15 13:14:02 2034 PST
1757 | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sun Dec 31 17:32:01 2034 PST
1758 | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Mon Jan 01 17:32:01 2035 PST
1759 | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Sat Sep 22 18:19:20 2035 PDT
1762 SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 - t.f1 AS minus
1763 FROM TEMP_TIMESTAMP d, INTERVAL_TBL t
1764 WHERE isfinite(d.f1)
1765 ORDER BY minus, "timestamp", "interval";
1766 160 | timestamp | interval | minus
1767 -----+------------------------------+-------------------------------+------------------------------
1768 | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Wed Jan 01 00:00:00 1936 PST
1769 | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST
1770 | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST
1771 | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 17:32:01 1962 PST
1772 | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 17:32:01 1962 PST
1773 | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 17:32:01 1962 PST
1774 | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Wed Jan 01 00:00:00 1964 PST
1775 | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 17:32:01 1965 PST
1776 | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 17:32:01 1966 PST
1777 | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Tue Mar 15 02:14:05 1966 PST
1778 | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Tue Mar 15 03:14:04 1966 PST
1779 | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 08:14:01 1966 PST
1780 | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Tue Mar 15 12:14:03 1966 PST
1781 | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 13:14:02 1966 PST
1782 | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST
1783 | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST
1784 | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 18:19:20 1967 PST
1785 | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 12:00:00 1969 PST
1786 | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Fri Aug 01 00:00:00 1969 PST
1787 | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Oct 01 00:00:00 1969 PST
1788 | Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST
1789 | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
1790 | Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST
1791 | Thu Jan 01 00:00:00 1970 PST | @ 1 min | Wed Dec 31 23:59:00 1969 PST
1792 | Thu Jan 01 00:00:00 1970 PST | @ 14 secs ago | Thu Jan 01 00:00:14 1970 PST
1793 | Wed Feb 28 17:32:01 1996 PST | @ 6 years | Wed Feb 28 17:32:01 1990 PST
1794 | Thu Feb 29 17:32:01 1996 PST | @ 6 years | Wed Feb 28 17:32:01 1990 PST
1795 | Fri Mar 01 17:32:01 1996 PST | @ 6 years | Thu Mar 01 17:32:01 1990 PST
1796 | Mon Dec 30 17:32:01 1996 PST | @ 6 years | Sun Dec 30 17:32:01 1990 PST
1797 | Tue Dec 31 17:32:01 1996 PST | @ 6 years | Mon Dec 31 17:32:01 1990 PST
1798 | Fri Dec 31 17:32:01 1999 PST | @ 6 years | Fri Dec 31 17:32:01 1993 PST
1799 | Sat Jan 01 17:32:01 2000 PST | @ 6 years | Sat Jan 01 17:32:01 1994 PST
1800 | Wed Mar 15 02:14:05 2000 PST | @ 6 years | Tue Mar 15 02:14:05 1994 PST
1801 | Wed Mar 15 03:14:04 2000 PST | @ 6 years | Tue Mar 15 03:14:04 1994 PST
1802 | Wed Mar 15 08:14:01 2000 PST | @ 6 years | Tue Mar 15 08:14:01 1994 PST
1803 | Wed Mar 15 12:14:03 2000 PST | @ 6 years | Tue Mar 15 12:14:03 1994 PST
1804 | Wed Mar 15 13:14:02 2000 PST | @ 6 years | Tue Mar 15 13:14:02 1994 PST
1805 | Sun Dec 31 17:32:01 2000 PST | @ 6 years | Sat Dec 31 17:32:01 1994 PST
1806 | Mon Jan 01 17:32:01 2001 PST | @ 6 years | Sun Jan 01 17:32:01 1995 PST
1807 | Sat Sep 22 18:19:20 2001 PDT | @ 6 years | Fri Sep 22 18:19:20 1995 PDT
1808 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours | Thu Sep 28 05:32:01 1995 PDT
1809 | Wed Feb 28 17:32:01 1996 PST | @ 5 mons | Thu Sep 28 17:32:01 1995 PDT
1810 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours | Fri Sep 29 05:32:01 1995 PDT
1811 | Thu Feb 29 17:32:01 1996 PST | @ 5 mons | Fri Sep 29 17:32:01 1995 PDT
1812 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours | Sun Oct 01 05:32:01 1995 PDT
1813 | Fri Mar 01 17:32:01 1996 PST | @ 5 mons | Sun Oct 01 17:32:01 1995 PDT
1814 | Wed Feb 28 17:32:01 1996 PST | @ 3 mons | Tue Nov 28 17:32:01 1995 PST
1815 | Thu Feb 29 17:32:01 1996 PST | @ 3 mons | Wed Nov 29 17:32:01 1995 PST
1816 | Fri Mar 01 17:32:01 1996 PST | @ 3 mons | Fri Dec 01 17:32:01 1995 PST
1817 | Wed Feb 28 17:32:01 1996 PST | @ 10 days | Sun Feb 18 17:32:01 1996 PST
1818 | Thu Feb 29 17:32:01 1996 PST | @ 10 days | Mon Feb 19 17:32:01 1996 PST
1819 | Fri Mar 01 17:32:01 1996 PST | @ 10 days | Tue Feb 20 17:32:01 1996 PST
1820 | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Feb 27 15:28:57 1996 PST
1821 | Wed Feb 28 17:32:01 1996 PST | @ 5 hours | Wed Feb 28 12:32:01 1996 PST
1822 | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Feb 28 15:28:57 1996 PST
1823 | Wed Feb 28 17:32:01 1996 PST | @ 1 min | Wed Feb 28 17:31:01 1996 PST
1824 | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago | Wed Feb 28 17:32:15 1996 PST
1825 | Thu Feb 29 17:32:01 1996 PST | @ 5 hours | Thu Feb 29 12:32:01 1996 PST
1826 | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 15:28:57 1996 PST
1827 | Thu Feb 29 17:32:01 1996 PST | @ 1 min | Thu Feb 29 17:31:01 1996 PST
1828 | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago | Thu Feb 29 17:32:15 1996 PST
1829 | Fri Mar 01 17:32:01 1996 PST | @ 5 hours | Fri Mar 01 12:32:01 1996 PST
1830 | Fri Mar 01 17:32:01 1996 PST | @ 1 min | Fri Mar 01 17:31:01 1996 PST
1831 | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago | Fri Mar 01 17:32:15 1996 PST
1832 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours | Tue Jul 30 05:32:01 1996 PDT
1833 | Mon Dec 30 17:32:01 1996 PST | @ 5 mons | Tue Jul 30 17:32:01 1996 PDT
1834 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours | Wed Jul 31 05:32:01 1996 PDT
1835 | Tue Dec 31 17:32:01 1996 PST | @ 5 mons | Wed Jul 31 17:32:01 1996 PDT
1836 | Mon Dec 30 17:32:01 1996 PST | @ 3 mons | Mon Sep 30 17:32:01 1996 PDT
1837 | Tue Dec 31 17:32:01 1996 PST | @ 3 mons | Mon Sep 30 17:32:01 1996 PDT
1838 | Mon Dec 30 17:32:01 1996 PST | @ 10 days | Fri Dec 20 17:32:01 1996 PST
1839 | Tue Dec 31 17:32:01 1996 PST | @ 10 days | Sat Dec 21 17:32:01 1996 PST
1840 | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 29 15:28:57 1996 PST
1841 | Mon Dec 30 17:32:01 1996 PST | @ 5 hours | Mon Dec 30 12:32:01 1996 PST
1842 | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Dec 30 15:28:57 1996 PST
1843 | Mon Dec 30 17:32:01 1996 PST | @ 1 min | Mon Dec 30 17:31:01 1996 PST
1844 | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago | Mon Dec 30 17:32:15 1996 PST
1845 | Tue Dec 31 17:32:01 1996 PST | @ 5 hours | Tue Dec 31 12:32:01 1996 PST
1846 | Tue Dec 31 17:32:01 1996 PST | @ 1 min | Tue Dec 31 17:31:01 1996 PST
1847 | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago | Tue Dec 31 17:32:15 1996 PST
1848 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours | Sat Jul 31 05:32:01 1999 PDT
1849 | Fri Dec 31 17:32:01 1999 PST | @ 5 mons | Sat Jul 31 17:32:01 1999 PDT
1850 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours | Sun Aug 01 05:32:01 1999 PDT
1851 | Sat Jan 01 17:32:01 2000 PST | @ 5 mons | Sun Aug 01 17:32:01 1999 PDT
1852 | Fri Dec 31 17:32:01 1999 PST | @ 3 mons | Thu Sep 30 17:32:01 1999 PDT
1853 | Sat Jan 01 17:32:01 2000 PST | @ 3 mons | Fri Oct 01 17:32:01 1999 PDT
1854 | Wed Mar 15 02:14:05 2000 PST | @ 5 mons 12 hours | Thu Oct 14 14:14:05 1999 PDT
1855 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours | Thu Oct 14 15:14:04 1999 PDT
1856 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours | Thu Oct 14 20:14:01 1999 PDT
1857 | Wed Mar 15 12:14:03 2000 PST | @ 5 mons 12 hours | Fri Oct 15 00:14:03 1999 PDT
1858 | Wed Mar 15 13:14:02 2000 PST | @ 5 mons 12 hours | Fri Oct 15 01:14:02 1999 PDT
1859 | Wed Mar 15 02:14:05 2000 PST | @ 5 mons | Fri Oct 15 02:14:05 1999 PDT
1860 | Wed Mar 15 03:14:04 2000 PST | @ 5 mons | Fri Oct 15 03:14:04 1999 PDT
1861 | Wed Mar 15 08:14:01 2000 PST | @ 5 mons | Fri Oct 15 08:14:01 1999 PDT
1862 | Wed Mar 15 12:14:03 2000 PST | @ 5 mons | Fri Oct 15 12:14:03 1999 PDT
1863 | Wed Mar 15 13:14:02 2000 PST | @ 5 mons | Fri Oct 15 13:14:02 1999 PDT
1864 | Wed Mar 15 02:14:05 2000 PST | @ 3 mons | Wed Dec 15 02:14:05 1999 PST
1865 | Wed Mar 15 03:14:04 2000 PST | @ 3 mons | Wed Dec 15 03:14:04 1999 PST
1866 | Wed Mar 15 08:14:01 2000 PST | @ 3 mons | Wed Dec 15 08:14:01 1999 PST
1867 | Wed Mar 15 12:14:03 2000 PST | @ 3 mons | Wed Dec 15 12:14:03 1999 PST
1868 | Wed Mar 15 13:14:02 2000 PST | @ 3 mons | Wed Dec 15 13:14:02 1999 PST
1869 | Fri Dec 31 17:32:01 1999 PST | @ 10 days | Tue Dec 21 17:32:01 1999 PST
1870 | Sat Jan 01 17:32:01 2000 PST | @ 10 days | Wed Dec 22 17:32:01 1999 PST
1871 | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Dec 30 15:28:57 1999 PST
1872 | Fri Dec 31 17:32:01 1999 PST | @ 5 hours | Fri Dec 31 12:32:01 1999 PST
1873 | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Dec 31 15:28:57 1999 PST
1874 | Fri Dec 31 17:32:01 1999 PST | @ 1 min | Fri Dec 31 17:31:01 1999 PST
1875 | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago | Fri Dec 31 17:32:15 1999 PST
1876 | Sat Jan 01 17:32:01 2000 PST | @ 5 hours | Sat Jan 01 12:32:01 2000 PST
1877 | Sat Jan 01 17:32:01 2000 PST | @ 1 min | Sat Jan 01 17:31:01 2000 PST
1878 | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago | Sat Jan 01 17:32:15 2000 PST
1879 | Wed Mar 15 02:14:05 2000 PST | @ 10 days | Sun Mar 05 02:14:05 2000 PST
1880 | Wed Mar 15 03:14:04 2000 PST | @ 10 days | Sun Mar 05 03:14:04 2000 PST
1881 | Wed Mar 15 08:14:01 2000 PST | @ 10 days | Sun Mar 05 08:14:01 2000 PST
1882 | Wed Mar 15 12:14:03 2000 PST | @ 10 days | Sun Mar 05 12:14:03 2000 PST
1883 | Wed Mar 15 13:14:02 2000 PST | @ 10 days | Sun Mar 05 13:14:02 2000 PST
1884 | Wed Mar 15 02:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 00:11:01 2000 PST
1885 | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 01:11:00 2000 PST
1886 | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 06:10:57 2000 PST
1887 | Wed Mar 15 12:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 10:10:59 2000 PST
1888 | Wed Mar 15 13:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 11:10:58 2000 PST
1889 | Wed Mar 15 02:14:05 2000 PST | @ 5 hours | Tue Mar 14 21:14:05 2000 PST
1890 | Wed Mar 15 03:14:04 2000 PST | @ 5 hours | Tue Mar 14 22:14:04 2000 PST
1891 | Wed Mar 15 02:14:05 2000 PST | @ 1 min | Wed Mar 15 02:13:05 2000 PST
1892 | Wed Mar 15 02:14:05 2000 PST | @ 14 secs ago | Wed Mar 15 02:14:19 2000 PST
1893 | Wed Mar 15 03:14:04 2000 PST | @ 1 min | Wed Mar 15 03:13:04 2000 PST
1894 | Wed Mar 15 08:14:01 2000 PST | @ 5 hours | Wed Mar 15 03:14:01 2000 PST
1895 | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago | Wed Mar 15 03:14:18 2000 PST
1896 | Wed Mar 15 12:14:03 2000 PST | @ 5 hours | Wed Mar 15 07:14:03 2000 PST
1897 | Wed Mar 15 08:14:01 2000 PST | @ 1 min | Wed Mar 15 08:13:01 2000 PST
1898 | Wed Mar 15 13:14:02 2000 PST | @ 5 hours | Wed Mar 15 08:14:02 2000 PST
1899 | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago | Wed Mar 15 08:14:15 2000 PST
1900 | Wed Mar 15 12:14:03 2000 PST | @ 1 min | Wed Mar 15 12:13:03 2000 PST
1901 | Wed Mar 15 12:14:03 2000 PST | @ 14 secs ago | Wed Mar 15 12:14:17 2000 PST
1902 | Wed Mar 15 13:14:02 2000 PST | @ 1 min | Wed Mar 15 13:13:02 2000 PST
1903 | Wed Mar 15 13:14:02 2000 PST | @ 14 secs ago | Wed Mar 15 13:14:16 2000 PST
1904 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours | Mon Jul 31 05:32:01 2000 PDT
1905 | Sun Dec 31 17:32:01 2000 PST | @ 5 mons | Mon Jul 31 17:32:01 2000 PDT
1906 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours | Tue Aug 01 05:32:01 2000 PDT
1907 | Mon Jan 01 17:32:01 2001 PST | @ 5 mons | Tue Aug 01 17:32:01 2000 PDT
1908 | Sun Dec 31 17:32:01 2000 PST | @ 3 mons | Sat Sep 30 17:32:01 2000 PDT
1909 | Mon Jan 01 17:32:01 2001 PST | @ 3 mons | Sun Oct 01 17:32:01 2000 PDT
1910 | Sun Dec 31 17:32:01 2000 PST | @ 10 days | Thu Dec 21 17:32:01 2000 PST
1911 | Mon Jan 01 17:32:01 2001 PST | @ 10 days | Fri Dec 22 17:32:01 2000 PST
1912 | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Dec 30 15:28:57 2000 PST
1913 | Sun Dec 31 17:32:01 2000 PST | @ 5 hours | Sun Dec 31 12:32:01 2000 PST
1914 | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 31 15:28:57 2000 PST
1915 | Sun Dec 31 17:32:01 2000 PST | @ 1 min | Sun Dec 31 17:31:01 2000 PST
1916 | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago | Sun Dec 31 17:32:15 2000 PST
1917 | Mon Jan 01 17:32:01 2001 PST | @ 5 hours | Mon Jan 01 12:32:01 2001 PST
1918 | Mon Jan 01 17:32:01 2001 PST | @ 1 min | Mon Jan 01 17:31:01 2001 PST
1919 | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago | Mon Jan 01 17:32:15 2001 PST
1920 | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons 12 hours | Sun Apr 22 06:19:20 2001 PDT
1921 | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons | Sun Apr 22 18:19:20 2001 PDT
1922 | Sat Sep 22 18:19:20 2001 PDT | @ 3 mons | Fri Jun 22 18:19:20 2001 PDT
1923 | Sat Sep 22 18:19:20 2001 PDT | @ 10 days | Wed Sep 12 18:19:20 2001 PDT
1924 | Sat Sep 22 18:19:20 2001 PDT | @ 1 day 2 hours 3 mins 4 secs | Fri Sep 21 16:16:16 2001 PDT
1925 | Sat Sep 22 18:19:20 2001 PDT | @ 5 hours | Sat Sep 22 13:19:20 2001 PDT
1926 | Sat Sep 22 18:19:20 2001 PDT | @ 1 min | Sat Sep 22 18:18:20 2001 PDT
1927 | Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago | Sat Sep 22 18:19:34 2001 PDT
1930 SELECT '' AS "16", d.f1 AS "timestamp",
1931 timestamp with time zone '1980-01-06 00:00 GMT' AS gpstime_zero,
1932 d.f1 - timestamp with time zone '1980-01-06 00:00 GMT' AS difference
1933 FROM TEMP_TIMESTAMP d
1934 ORDER BY difference;
1935 16 | timestamp | gpstime_zero | difference
1936 ----+------------------------------+------------------------------+-------------------------------------
1937 | Thu Jan 01 00:00:00 1970 PST | Sat Jan 05 16:00:00 1980 PST | @ 3656 days 16 hours ago
1938 | Wed Feb 28 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 5898 days 1 hour 32 mins 1 sec
1939 | Thu Feb 29 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 5899 days 1 hour 32 mins 1 sec
1940 | Fri Mar 01 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 5900 days 1 hour 32 mins 1 sec
1941 | Mon Dec 30 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 6204 days 1 hour 32 mins 1 sec
1942 | Tue Dec 31 17:32:01 1996 PST | Sat Jan 05 16:00:00 1980 PST | @ 6205 days 1 hour 32 mins 1 sec
1943 | Fri Dec 31 17:32:01 1999 PST | Sat Jan 05 16:00:00 1980 PST | @ 7300 days 1 hour 32 mins 1 sec
1944 | Sat Jan 01 17:32:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7301 days 1 hour 32 mins 1 sec
1945 | Wed Mar 15 02:14:05 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 10 hours 14 mins 5 secs
1946 | Wed Mar 15 03:14:04 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 11 hours 14 mins 4 secs
1947 | Wed Mar 15 08:14:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 16 hours 14 mins 1 sec
1948 | Wed Mar 15 12:14:03 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 20 hours 14 mins 3 secs
1949 | Wed Mar 15 13:14:02 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 21 hours 14 mins 2 secs
1950 | Sun Dec 31 17:32:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7666 days 1 hour 32 mins 1 sec
1951 | Mon Jan 01 17:32:01 2001 PST | Sat Jan 05 16:00:00 1980 PST | @ 7667 days 1 hour 32 mins 1 sec
1952 | Sat Sep 22 18:19:20 2001 PDT | Sat Jan 05 16:00:00 1980 PST | @ 7931 days 1 hour 19 mins 20 secs
1955 SELECT '' AS "226", d1.f1 AS timestamp1, d2.f1 AS timestamp2, d1.f1 - d2.f1 AS difference
1956 FROM TEMP_TIMESTAMP d1, TEMP_TIMESTAMP d2
1957 ORDER BY timestamp1, timestamp2, difference;
1958 226 | timestamp1 | timestamp2 | difference
1959 -----+------------------------------+------------------------------+-------------------------------------------
1960 | Thu Jan 01 00:00:00 1970 PST | Thu Jan 01 00:00:00 1970 PST | @ 0
1961 | Thu Jan 01 00:00:00 1970 PST | Wed Feb 28 17:32:01 1996 PST | @ 9554 days 17 hours 32 mins 1 sec ago
1962 | Thu Jan 01 00:00:00 1970 PST | Thu Feb 29 17:32:01 1996 PST | @ 9555 days 17 hours 32 mins 1 sec ago
1963 | Thu Jan 01 00:00:00 1970 PST | Fri Mar 01 17:32:01 1996 PST | @ 9556 days 17 hours 32 mins 1 sec ago
1964 | Thu Jan 01 00:00:00 1970 PST | Mon Dec 30 17:32:01 1996 PST | @ 9860 days 17 hours 32 mins 1 sec ago
1965 | Thu Jan 01 00:00:00 1970 PST | Tue Dec 31 17:32:01 1996 PST | @ 9861 days 17 hours 32 mins 1 sec ago
1966 | Thu Jan 01 00:00:00 1970 PST | Fri Dec 31 17:32:01 1999 PST | @ 10956 days 17 hours 32 mins 1 sec ago
1967 | Thu Jan 01 00:00:00 1970 PST | Sat Jan 01 17:32:01 2000 PST | @ 10957 days 17 hours 32 mins 1 sec ago
1968 | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 02:14:05 2000 PST | @ 11031 days 2 hours 14 mins 5 secs ago
1969 | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 03:14:04 2000 PST | @ 11031 days 3 hours 14 mins 4 secs ago
1970 | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 08:14:01 2000 PST | @ 11031 days 8 hours 14 mins 1 sec ago
1971 | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 12:14:03 2000 PST | @ 11031 days 12 hours 14 mins 3 secs ago
1972 | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 13:14:02 2000 PST | @ 11031 days 13 hours 14 mins 2 secs ago
1973 | Thu Jan 01 00:00:00 1970 PST | Sun Dec 31 17:32:01 2000 PST | @ 11322 days 17 hours 32 mins 1 sec ago
1974 | Thu Jan 01 00:00:00 1970 PST | Mon Jan 01 17:32:01 2001 PST | @ 11323 days 17 hours 32 mins 1 sec ago
1975 | Thu Jan 01 00:00:00 1970 PST | Sat Sep 22 18:19:20 2001 PDT | @ 11587 days 17 hours 19 mins 20 secs ago
1976 | Wed Feb 28 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9554 days 17 hours 32 mins 1 sec
1977 | Wed Feb 28 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 0
1978 | Wed Feb 28 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 1 day ago
1979 | Wed Feb 28 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 2 days ago
1980 | Wed Feb 28 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 306 days ago
1981 | Wed Feb 28 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 307 days ago
1982 | Wed Feb 28 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1402 days ago
1983 | Wed Feb 28 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1403 days ago
1984 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1476 days 8 hours 42 mins 4 secs ago
1985 | 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
1986 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1476 days 14 hours 42 mins ago
1987 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1476 days 18 hours 42 mins 2 secs ago
1988 | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1476 days 19 hours 42 mins 1 sec ago
1989 | Wed Feb 28 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1768 days ago
1990 | Wed Feb 28 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1769 days ago
1991 | Wed Feb 28 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2032 days 23 hours 47 mins 19 secs ago
1992 | Thu Feb 29 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9555 days 17 hours 32 mins 1 sec
1993 | Thu Feb 29 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 1 day
1994 | Thu Feb 29 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 0
1995 | Thu Feb 29 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 1 day ago
1996 | Thu Feb 29 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 305 days ago
1997 | Thu Feb 29 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 306 days ago
1998 | Thu Feb 29 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1401 days ago
1999 | Thu Feb 29 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1402 days ago
2000 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1475 days 8 hours 42 mins 4 secs ago
2001 | 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
2002 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1475 days 14 hours 42 mins ago
2003 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1475 days 18 hours 42 mins 2 secs ago
2004 | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1475 days 19 hours 42 mins 1 sec ago
2005 | Thu Feb 29 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1767 days ago
2006 | Thu Feb 29 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1768 days ago
2007 | Thu Feb 29 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2031 days 23 hours 47 mins 19 secs ago
2008 | Fri Mar 01 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9556 days 17 hours 32 mins 1 sec
2009 | Fri Mar 01 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 2 days
2010 | Fri Mar 01 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 1 day
2011 | Fri Mar 01 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 0
2012 | Fri Mar 01 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 304 days ago
2013 | Fri Mar 01 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 305 days ago
2014 | Fri Mar 01 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1400 days ago
2015 | Fri Mar 01 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1401 days ago
2016 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1474 days 8 hours 42 mins 4 secs ago
2017 | 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
2018 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1474 days 14 hours 42 mins ago
2019 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1474 days 18 hours 42 mins 2 secs ago
2020 | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1474 days 19 hours 42 mins 1 sec ago
2021 | Fri Mar 01 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1766 days ago
2022 | Fri Mar 01 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1767 days ago
2023 | Fri Mar 01 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2030 days 23 hours 47 mins 19 secs ago
2024 | Mon Dec 30 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9860 days 17 hours 32 mins 1 sec
2025 | Mon Dec 30 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 306 days
2026 | Mon Dec 30 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 305 days
2027 | Mon Dec 30 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 304 days
2028 | Mon Dec 30 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 0
2029 | Mon Dec 30 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 1 day ago
2030 | Mon Dec 30 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1096 days ago
2031 | Mon Dec 30 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1097 days ago
2032 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1170 days 8 hours 42 mins 4 secs ago
2033 | 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
2034 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1170 days 14 hours 42 mins ago
2035 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1170 days 18 hours 42 mins 2 secs ago
2036 | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1170 days 19 hours 42 mins 1 sec ago
2037 | Mon Dec 30 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1462 days ago
2038 | Mon Dec 30 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1463 days ago
2039 | Mon Dec 30 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 1726 days 23 hours 47 mins 19 secs ago
2040 | Tue Dec 31 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9861 days 17 hours 32 mins 1 sec
2041 | Tue Dec 31 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 307 days
2042 | Tue Dec 31 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 306 days
2043 | Tue Dec 31 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 305 days
2044 | Tue Dec 31 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 1 day
2045 | Tue Dec 31 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 0
2046 | Tue Dec 31 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1095 days ago
2047 | Tue Dec 31 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1096 days ago
2048 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1169 days 8 hours 42 mins 4 secs ago
2049 | 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
2050 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1169 days 14 hours 42 mins ago
2051 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1169 days 18 hours 42 mins 2 secs ago
2052 | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1169 days 19 hours 42 mins 1 sec ago
2053 | Tue Dec 31 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1461 days ago
2054 | Tue Dec 31 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1462 days ago
2055 | Tue Dec 31 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 1725 days 23 hours 47 mins 19 secs ago
2056 | Fri Dec 31 17:32:01 1999 PST | Thu Jan 01 00:00:00 1970 PST | @ 10956 days 17 hours 32 mins 1 sec
2057 | Fri Dec 31 17:32:01 1999 PST | Wed Feb 28 17:32:01 1996 PST | @ 1402 days
2058 | Fri Dec 31 17:32:01 1999 PST | Thu Feb 29 17:32:01 1996 PST | @ 1401 days
2059 | Fri Dec 31 17:32:01 1999 PST | Fri Mar 01 17:32:01 1996 PST | @ 1400 days
2060 | Fri Dec 31 17:32:01 1999 PST | Mon Dec 30 17:32:01 1996 PST | @ 1096 days
2061 | Fri Dec 31 17:32:01 1999 PST | Tue Dec 31 17:32:01 1996 PST | @ 1095 days
2062 | Fri Dec 31 17:32:01 1999 PST | Fri Dec 31 17:32:01 1999 PST | @ 0
2063 | Fri Dec 31 17:32:01 1999 PST | Sat Jan 01 17:32:01 2000 PST | @ 1 day ago
2064 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 02:14:05 2000 PST | @ 74 days 8 hours 42 mins 4 secs ago
2065 | 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
2066 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 08:14:01 2000 PST | @ 74 days 14 hours 42 mins ago
2067 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 12:14:03 2000 PST | @ 74 days 18 hours 42 mins 2 secs ago
2068 | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 13:14:02 2000 PST | @ 74 days 19 hours 42 mins 1 sec ago
2069 | Fri Dec 31 17:32:01 1999 PST | Sun Dec 31 17:32:01 2000 PST | @ 366 days ago
2070 | Fri Dec 31 17:32:01 1999 PST | Mon Jan 01 17:32:01 2001 PST | @ 367 days ago
2071 | Fri Dec 31 17:32:01 1999 PST | Sat Sep 22 18:19:20 2001 PDT | @ 630 days 23 hours 47 mins 19 secs ago
2072 | Sat Jan 01 17:32:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 10957 days 17 hours 32 mins 1 sec
2073 | Sat Jan 01 17:32:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1403 days
2074 | Sat Jan 01 17:32:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1402 days
2075 | Sat Jan 01 17:32:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1401 days
2076 | Sat Jan 01 17:32:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1097 days
2077 | Sat Jan 01 17:32:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1096 days
2078 | Sat Jan 01 17:32:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 1 day
2079 | Sat Jan 01 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 0
2080 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 73 days 8 hours 42 mins 4 secs ago
2081 | 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
2082 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 73 days 14 hours 42 mins ago
2083 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 73 days 18 hours 42 mins 2 secs ago
2084 | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 73 days 19 hours 42 mins 1 sec ago
2085 | Sat Jan 01 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 365 days ago
2086 | Sat Jan 01 17:32:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 366 days ago
2087 | Sat Jan 01 17:32:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 629 days 23 hours 47 mins 19 secs ago
2088 | Wed Mar 15 02:14:05 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 2 hours 14 mins 5 secs
2089 | Wed Mar 15 02:14:05 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 8 hours 42 mins 4 secs
2090 | Wed Mar 15 02:14:05 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 8 hours 42 mins 4 secs
2091 | Wed Mar 15 02:14:05 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 8 hours 42 mins 4 secs
2092 | Wed Mar 15 02:14:05 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 8 hours 42 mins 4 secs
2093 | Wed Mar 15 02:14:05 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 8 hours 42 mins 4 secs
2094 | Wed Mar 15 02:14:05 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 8 hours 42 mins 4 secs
2095 | Wed Mar 15 02:14:05 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 8 hours 42 mins 4 secs
2096 | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 0
2097 | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 59 mins 59 secs ago
2098 | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 59 mins 56 secs ago
2099 | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 9 hours 59 mins 58 secs ago
2100 | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 10 hours 59 mins 57 secs ago
2101 | Wed Mar 15 02:14:05 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 15 hours 17 mins 56 secs ago
2102 | Wed Mar 15 02:14:05 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 15 hours 17 mins 56 secs ago
2103 | Wed Mar 15 02:14:05 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 15 hours 5 mins 15 secs ago
2104 | Wed Mar 15 03:14:04 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 3 hours 14 mins 4 secs
2105 | Wed Mar 15 03:14:04 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 9 hours 42 mins 3 secs
2106 | Wed Mar 15 03:14:04 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 9 hours 42 mins 3 secs
2107 | Wed Mar 15 03:14:04 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 9 hours 42 mins 3 secs
2108 | Wed Mar 15 03:14:04 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 9 hours 42 mins 3 secs
2109 | Wed Mar 15 03:14:04 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 9 hours 42 mins 3 secs
2110 | Wed Mar 15 03:14:04 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 9 hours 42 mins 3 secs
2111 | Wed Mar 15 03:14:04 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 9 hours 42 mins 3 secs
2112 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 59 mins 59 secs
2113 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 0
2114 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 59 mins 57 secs ago
2115 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 8 hours 59 mins 59 secs ago
2116 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 9 hours 59 mins 58 secs ago
2117 | 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
2118 | 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
2119 | Wed Mar 15 03:14:04 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 14 hours 5 mins 16 secs ago
2120 | Wed Mar 15 08:14:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 8 hours 14 mins 1 sec
2121 | Wed Mar 15 08:14:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 14 hours 42 mins
2122 | Wed Mar 15 08:14:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 14 hours 42 mins
2123 | Wed Mar 15 08:14:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 14 hours 42 mins
2124 | Wed Mar 15 08:14:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 14 hours 42 mins
2125 | Wed Mar 15 08:14:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 14 hours 42 mins
2126 | Wed Mar 15 08:14:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 14 hours 42 mins
2127 | Wed Mar 15 08:14:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 14 hours 42 mins
2128 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 5 hours 59 mins 56 secs
2129 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 4 hours 59 mins 57 secs
2130 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 0
2131 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 4 hours 2 secs ago
2132 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 5 hours 1 sec ago
2133 | Wed Mar 15 08:14:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 9 hours 18 mins ago
2134 | Wed Mar 15 08:14:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 9 hours 18 mins ago
2135 | Wed Mar 15 08:14:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 9 hours 5 mins 19 secs ago
2136 | Wed Mar 15 12:14:03 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 12 hours 14 mins 3 secs
2137 | Wed Mar 15 12:14:03 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 18 hours 42 mins 2 secs
2138 | Wed Mar 15 12:14:03 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 18 hours 42 mins 2 secs
2139 | Wed Mar 15 12:14:03 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 18 hours 42 mins 2 secs
2140 | Wed Mar 15 12:14:03 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 18 hours 42 mins 2 secs
2141 | Wed Mar 15 12:14:03 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 18 hours 42 mins 2 secs
2142 | Wed Mar 15 12:14:03 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 18 hours 42 mins 2 secs
2143 | Wed Mar 15 12:14:03 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 18 hours 42 mins 2 secs
2144 | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 9 hours 59 mins 58 secs
2145 | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 8 hours 59 mins 59 secs
2146 | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 2 secs
2147 | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 0
2148 | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 59 mins 59 secs ago
2149 | Wed Mar 15 12:14:03 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 5 hours 17 mins 58 secs ago
2150 | Wed Mar 15 12:14:03 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 5 hours 17 mins 58 secs ago
2151 | Wed Mar 15 12:14:03 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 5 hours 5 mins 17 secs ago
2152 | Wed Mar 15 13:14:02 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 13 hours 14 mins 2 secs
2153 | Wed Mar 15 13:14:02 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 19 hours 42 mins 1 sec
2154 | Wed Mar 15 13:14:02 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 19 hours 42 mins 1 sec
2155 | Wed Mar 15 13:14:02 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 19 hours 42 mins 1 sec
2156 | Wed Mar 15 13:14:02 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 19 hours 42 mins 1 sec
2157 | Wed Mar 15 13:14:02 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 19 hours 42 mins 1 sec
2158 | Wed Mar 15 13:14:02 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 19 hours 42 mins 1 sec
2159 | Wed Mar 15 13:14:02 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 19 hours 42 mins 1 sec
2160 | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 10 hours 59 mins 57 secs
2161 | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 9 hours 59 mins 58 secs
2162 | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 1 sec
2163 | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 59 mins 59 secs
2164 | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 0
2165 | Wed Mar 15 13:14:02 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 4 hours 17 mins 59 secs ago
2166 | Wed Mar 15 13:14:02 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 4 hours 17 mins 59 secs ago
2167 | Wed Mar 15 13:14:02 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 4 hours 5 mins 18 secs ago
2168 | Sun Dec 31 17:32:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11322 days 17 hours 32 mins 1 sec
2169 | Sun Dec 31 17:32:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1768 days
2170 | Sun Dec 31 17:32:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1767 days
2171 | Sun Dec 31 17:32:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1766 days
2172 | Sun Dec 31 17:32:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1462 days
2173 | Sun Dec 31 17:32:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1461 days
2174 | Sun Dec 31 17:32:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 366 days
2175 | Sun Dec 31 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 365 days
2176 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 291 days 15 hours 17 mins 56 secs
2177 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 291 days 14 hours 17 mins 57 secs
2178 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 291 days 9 hours 18 mins
2179 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 291 days 5 hours 17 mins 58 secs
2180 | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 291 days 4 hours 17 mins 59 secs
2181 | Sun Dec 31 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 0
2182 | Sun Dec 31 17:32:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 1 day ago
2183 | Sun Dec 31 17:32:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 264 days 23 hours 47 mins 19 secs ago
2184 | Mon Jan 01 17:32:01 2001 PST | Thu Jan 01 00:00:00 1970 PST | @ 11323 days 17 hours 32 mins 1 sec
2185 | Mon Jan 01 17:32:01 2001 PST | Wed Feb 28 17:32:01 1996 PST | @ 1769 days
2186 | Mon Jan 01 17:32:01 2001 PST | Thu Feb 29 17:32:01 1996 PST | @ 1768 days
2187 | Mon Jan 01 17:32:01 2001 PST | Fri Mar 01 17:32:01 1996 PST | @ 1767 days
2188 | Mon Jan 01 17:32:01 2001 PST | Mon Dec 30 17:32:01 1996 PST | @ 1463 days
2189 | Mon Jan 01 17:32:01 2001 PST | Tue Dec 31 17:32:01 1996 PST | @ 1462 days
2190 | Mon Jan 01 17:32:01 2001 PST | Fri Dec 31 17:32:01 1999 PST | @ 367 days
2191 | Mon Jan 01 17:32:01 2001 PST | Sat Jan 01 17:32:01 2000 PST | @ 366 days
2192 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 02:14:05 2000 PST | @ 292 days 15 hours 17 mins 56 secs
2193 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 03:14:04 2000 PST | @ 292 days 14 hours 17 mins 57 secs
2194 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 08:14:01 2000 PST | @ 292 days 9 hours 18 mins
2195 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 12:14:03 2000 PST | @ 292 days 5 hours 17 mins 58 secs
2196 | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 13:14:02 2000 PST | @ 292 days 4 hours 17 mins 59 secs
2197 | Mon Jan 01 17:32:01 2001 PST | Sun Dec 31 17:32:01 2000 PST | @ 1 day
2198 | Mon Jan 01 17:32:01 2001 PST | Mon Jan 01 17:32:01 2001 PST | @ 0
2199 | Mon Jan 01 17:32:01 2001 PST | Sat Sep 22 18:19:20 2001 PDT | @ 263 days 23 hours 47 mins 19 secs ago
2200 | Sat Sep 22 18:19:20 2001 PDT | Thu Jan 01 00:00:00 1970 PST | @ 11587 days 17 hours 19 mins 20 secs
2201 | Sat Sep 22 18:19:20 2001 PDT | Wed Feb 28 17:32:01 1996 PST | @ 2032 days 23 hours 47 mins 19 secs
2202 | Sat Sep 22 18:19:20 2001 PDT | Thu Feb 29 17:32:01 1996 PST | @ 2031 days 23 hours 47 mins 19 secs
2203 | Sat Sep 22 18:19:20 2001 PDT | Fri Mar 01 17:32:01 1996 PST | @ 2030 days 23 hours 47 mins 19 secs
2204 | Sat Sep 22 18:19:20 2001 PDT | Mon Dec 30 17:32:01 1996 PST | @ 1726 days 23 hours 47 mins 19 secs
2205 | Sat Sep 22 18:19:20 2001 PDT | Tue Dec 31 17:32:01 1996 PST | @ 1725 days 23 hours 47 mins 19 secs
2206 | Sat Sep 22 18:19:20 2001 PDT | Fri Dec 31 17:32:01 1999 PST | @ 630 days 23 hours 47 mins 19 secs
2207 | Sat Sep 22 18:19:20 2001 PDT | Sat Jan 01 17:32:01 2000 PST | @ 629 days 23 hours 47 mins 19 secs
2208 | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 02:14:05 2000 PST | @ 556 days 15 hours 5 mins 15 secs
2209 | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 03:14:04 2000 PST | @ 556 days 14 hours 5 mins 16 secs
2210 | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 08:14:01 2000 PST | @ 556 days 9 hours 5 mins 19 secs
2211 | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 12:14:03 2000 PST | @ 556 days 5 hours 5 mins 17 secs
2212 | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 13:14:02 2000 PST | @ 556 days 4 hours 5 mins 18 secs
2213 | Sat Sep 22 18:19:20 2001 PDT | Sun Dec 31 17:32:01 2000 PST | @ 264 days 23 hours 47 mins 19 secs
2214 | Sat Sep 22 18:19:20 2001 PDT | Mon Jan 01 17:32:01 2001 PST | @ 263 days 23 hours 47 mins 19 secs
2215 | Sat Sep 22 18:19:20 2001 PDT | Sat Sep 22 18:19:20 2001 PDT | @ 0
2219 -- abstime, reltime arithmetic
2221 SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime
2222 WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1) < abstime 'Jan 14 14:00:00 1971'
2223 ORDER BY abstime, reltime;
2224 ten | abstime | reltime
2225 -----+------------------------------+---------------
2226 | Sat May 10 23:59:12 1947 PST | @ 14 secs ago
2227 | Sat May 10 23:59:12 1947 PST | @ 1 min
2228 | Sat May 10 23:59:12 1947 PST | @ 5 hours
2229 | Sat May 10 23:59:12 1947 PST | @ 10 days
2230 | Sat May 10 23:59:12 1947 PST | @ 3 mons
2231 | Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago
2232 | Wed Dec 31 16:00:00 1969 PST | @ 1 min
2233 | Wed Dec 31 16:00:00 1969 PST | @ 5 hours
2234 | Wed Dec 31 16:00:00 1969 PST | @ 10 days
2235 | Wed Dec 31 16:00:00 1969 PST | @ 3 mons
2238 -- these four queries should return the same answer
2239 -- the "infinity" and "-infinity" tuples in ABSTIME_TBL cannot be added and
2240 -- therefore, should not show up in the results.
2241 SELECT '' AS three, ABSTIME_TBL.*
2242 WHERE (ABSTIME_TBL.f1 + reltime '@ 3 year') -- +3 years
2243 < abstime 'Jan 14 14:00:00 1977';
2245 -------+------------------------------
2246 | Sun Jan 14 03:14:21 1973 PST
2247 | Wed Dec 31 16:00:00 1969 PST
2248 | Sat May 10 23:59:12 1947 PST
2251 SELECT '' AS three, ABSTIME_TBL.*
2252 WHERE (ABSTIME_TBL.f1 + reltime '@ 3 year ago') -- -3 years
2253 < abstime 'Jan 14 14:00:00 1971';
2255 -------+------------------------------
2256 | Sun Jan 14 03:14:21 1973 PST
2257 | Wed Dec 31 16:00:00 1969 PST
2258 | Sat May 10 23:59:12 1947 PST
2261 SELECT '' AS three, ABSTIME_TBL.*
2262 WHERE (ABSTIME_TBL.f1 - reltime '@ 3 year') -- -(+3) years
2263 < abstime 'Jan 14 14:00:00 1971';
2265 -------+------------------------------
2266 | Sun Jan 14 03:14:21 1973 PST
2267 | Wed Dec 31 16:00:00 1969 PST
2268 | Sat May 10 23:59:12 1947 PST
2271 SELECT '' AS three, ABSTIME_TBL.*
2272 WHERE (ABSTIME_TBL.f1 - reltime '@ 3 year ago') -- -(-3) years
2273 < abstime 'Jan 14 14:00:00 1977';
2275 -------+------------------------------
2276 | Sun Jan 14 03:14:21 1973 PST
2277 | Wed Dec 31 16:00:00 1969 PST
2278 | Sat May 10 23:59:12 1947 PST
2284 SELECT '' AS "16", f1 AS "timestamp", date(f1) AS date
2286 WHERE f1 <> timestamp 'now'
2287 ORDER BY date, "timestamp";
2288 16 | timestamp | date
2289 ----+------------------------------+------------
2290 | Thu Jan 01 00:00:00 1970 PST | 01-01-1970
2291 | Wed Feb 28 17:32:01 1996 PST | 02-28-1996
2292 | Thu Feb 29 17:32:01 1996 PST | 02-29-1996
2293 | Fri Mar 01 17:32:01 1996 PST | 03-01-1996
2294 | Mon Dec 30 17:32:01 1996 PST | 12-30-1996
2295 | Tue Dec 31 17:32:01 1996 PST | 12-31-1996
2296 | Fri Dec 31 17:32:01 1999 PST | 12-31-1999
2297 | Sat Jan 01 17:32:01 2000 PST | 01-01-2000
2298 | Wed Mar 15 02:14:05 2000 PST | 03-15-2000
2299 | Wed Mar 15 03:14:04 2000 PST | 03-15-2000
2300 | Wed Mar 15 08:14:01 2000 PST | 03-15-2000
2301 | Wed Mar 15 12:14:03 2000 PST | 03-15-2000
2302 | Wed Mar 15 13:14:02 2000 PST | 03-15-2000
2303 | Sun Dec 31 17:32:01 2000 PST | 12-31-2000
2304 | Mon Jan 01 17:32:01 2001 PST | 01-01-2001
2305 | Sat Sep 22 18:19:20 2001 PDT | 09-22-2001
2308 SELECT '' AS "16", f1 AS "timestamp", abstime(f1) AS abstime
2311 16 | timestamp | abstime
2312 ----+------------------------------+------------------------------
2313 | Thu Jan 01 00:00:00 1970 PST | Thu Jan 01 00:00:00 1970 PST
2314 | Wed Feb 28 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST
2315 | Thu Feb 29 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST
2316 | Fri Mar 01 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST
2317 | Mon Dec 30 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST
2318 | Tue Dec 31 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST
2319 | Fri Dec 31 17:32:01 1999 PST | Fri Dec 31 17:32:01 1999 PST
2320 | Sat Jan 01 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST
2321 | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 02:14:05 2000 PST
2322 | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST
2323 | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST
2324 | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 12:14:03 2000 PST
2325 | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 13:14:02 2000 PST
2326 | Sun Dec 31 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST
2327 | Mon Jan 01 17:32:01 2001 PST | Mon Jan 01 17:32:01 2001 PST
2328 | Sat Sep 22 18:19:20 2001 PDT | Sat Sep 22 18:19:20 2001 PDT
2331 SELECT '' AS four, f1 AS abstime, date(f1) AS date
2333 WHERE isfinite(f1) AND f1 <> abstime 'now'
2334 ORDER BY date, abstime;
2335 four | abstime | date
2336 ------+------------------------------+------------
2337 | Sat May 10 23:59:12 1947 PST | 05-10-1947
2338 | Wed Dec 31 16:00:00 1969 PST | 12-31-1969
2339 | Sun Jan 14 03:14:21 1973 PST | 01-14-1973
2340 | Mon May 01 00:30:30 1995 PDT | 05-01-1995
2343 SELECT '' AS two, d1 AS "timestamp", abstime(d1) AS abstime
2344 FROM TIMESTAMP_TBL WHERE NOT isfinite(d1);
2345 two | timestamp | abstime
2346 -----+-----------+-----------
2347 | -infinity | -infinity
2348 | infinity | infinity
2351 SELECT '' AS three, f1 as abstime, cast(f1 as timestamp) AS "timestamp"
2352 FROM ABSTIME_TBL WHERE NOT isfinite(f1);
2353 ERROR: Unable to convert abstime 'invalid' to timestamp
2354 SELECT '' AS ten, f1 AS interval, reltime(f1) AS reltime
2356 ten | interval | reltime
2357 -----+-------------------------------+-------------------------------
2359 | @ 5 hours | @ 5 hours
2360 | @ 10 days | @ 10 days
2361 | @ 34 years | @ 34 years
2362 | @ 3 mons | @ 3 mons
2363 | @ 14 secs ago | @ 14 secs ago
2364 | @ 1 day 2 hours 3 mins 4 secs | @ 1 day 2 hours 3 mins 4 secs
2365 | @ 6 years | @ 6 years
2366 | @ 5 mons | @ 5 mons
2367 | @ 5 mons 12 hours | @ 5 mons 12 hours
2370 SELECT '' AS six, f1 as reltime, CAST(f1 AS interval) AS interval
2372 six | reltime | interval
2373 -----+---------------+---------------
2375 | @ 5 hours | @ 5 hours
2376 | @ 10 days | @ 10 days
2377 | @ 34 years | @ 34 years
2378 | @ 3 mons | @ 3 mons
2379 | @ 14 secs ago | @ 14 secs ago
2382 DROP TABLE TEMP_TIMESTAMP;
2386 SET DateStyle TO 'US,Postgres';
2393 SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL;
2395 ----+-----------------------------
2398 | Thu Jan 01 00:00:00 1970
2399 | Mon Feb 10 17:32:01 1997
2400 | Mon Feb 10 17:32:01 1997
2401 | Mon Feb 10 17:32:02 1997
2402 | Mon Feb 10 17:32:01.40 1997
2403 | Mon Feb 10 17:32:01.50 1997
2404 | Mon Feb 10 17:32:01.60 1997
2405 | Thu Jan 02 00:00:00 1997
2406 | Thu Jan 02 03:04:05 1997
2407 | Mon Feb 10 17:32:01 1997
2408 | Mon Feb 10 17:32:01 1997
2409 | Mon Feb 10 17:32:01 1997
2410 | Mon Feb 10 17:32:01 1997
2411 | Tue Jun 10 17:32:01 1997
2412 | Sat Sep 22 18:19:20 2001
2413 | Wed Mar 15 08:14:01 2000
2414 | Wed Mar 15 13:14:02 2000
2415 | Wed Mar 15 12:14:03 2000
2416 | Wed Mar 15 03:14:04 2000
2417 | Wed Mar 15 02:14:05 2000
2418 | Mon Feb 10 17:32:01 1997
2419 | Mon Feb 10 17:32:01 1997
2420 | Mon Feb 10 17:32:00 1997
2421 | Mon Feb 10 17:32:01 1997
2422 | Mon Feb 10 17:32:01 1997
2423 | Mon Feb 10 17:32:01 1997
2424 | Mon Feb 10 17:32:01 1997
2425 | Mon Feb 10 17:32:01 1997
2426 | Mon Feb 10 17:32:01 1997
2427 | Mon Feb 10 17:32:01 1997
2428 | Mon Feb 10 17:32:01 1997
2429 | Tue Jun 10 18:32:01 1997
2430 | Mon Feb 10 17:32:01 1997
2431 | Tue Feb 11 17:32:01 1997
2432 | Wed Feb 12 17:32:01 1997
2433 | Thu Feb 13 17:32:01 1997
2434 | Fri Feb 14 17:32:01 1997
2435 | Sat Feb 15 17:32:01 1997
2436 | Sun Feb 16 17:32:01 1997
2437 | Tue Feb 16 17:32:01 0097 BC
2438 | Sat Feb 16 17:32:01 0097
2439 | Thu Feb 16 17:32:01 0597
2440 | Tue Feb 16 17:32:01 1097
2441 | Sat Feb 16 17:32:01 1697
2442 | Thu Feb 16 17:32:01 1797
2443 | Tue Feb 16 17:32:01 1897
2444 | Sun Feb 16 17:32:01 1997
2445 | Sat Feb 16 17:32:01 2097
2446 | Wed Feb 28 17:32:01 1996
2447 | Thu Feb 29 17:32:01 1996
2448 | Fri Mar 01 17:32:01 1996
2449 | Mon Dec 30 17:32:01 1996
2450 | Tue Dec 31 17:32:01 1996
2451 | Wed Jan 01 17:32:01 1997
2452 | Fri Feb 28 17:32:01 1997
2453 | Sat Mar 01 17:32:01 1997
2454 | Tue Dec 30 17:32:01 1997
2455 | Wed Dec 31 17:32:01 1997
2456 | Fri Dec 31 17:32:01 1999
2457 | Sat Jan 01 17:32:01 2000
2458 | Sun Dec 31 17:32:01 2000
2459 | Mon Jan 01 17:32:01 2001
2462 SELECT '' AS seven, f1 AS us_postgres FROM ABSTIME_TBL;
2464 -------+------------------------------
2465 | Sun Jan 14 03:14:21 1973 PST
2466 | Mon May 01 00:30:30 1995 PDT
2467 | Wed Dec 31 16:00:00 1969 PST
2470 | Sat May 10 23:59:12 1947 PST
2474 SET DateStyle TO 'US,ISO';
2475 SELECT '' AS "64", d1 AS us_iso FROM TIMESTAMP_TBL;
2477 ----+------------------------
2480 | 1970-01-01 00:00:00
2481 | 1997-02-10 17:32:01
2482 | 1997-02-10 17:32:01
2483 | 1997-02-10 17:32:02
2484 | 1997-02-10 17:32:01.40
2485 | 1997-02-10 17:32:01.50
2486 | 1997-02-10 17:32:01.60
2487 | 1997-01-02 00:00:00
2488 | 1997-01-02 03:04:05
2489 | 1997-02-10 17:32:01
2490 | 1997-02-10 17:32:01
2491 | 1997-02-10 17:32:01
2492 | 1997-02-10 17:32:01
2493 | 1997-06-10 17:32:01
2494 | 2001-09-22 18:19:20
2495 | 2000-03-15 08:14:01
2496 | 2000-03-15 13:14:02
2497 | 2000-03-15 12:14:03
2498 | 2000-03-15 03:14:04
2499 | 2000-03-15 02:14:05
2500 | 1997-02-10 17:32:01
2501 | 1997-02-10 17:32:01
2502 | 1997-02-10 17:32:00
2503 | 1997-02-10 17:32:01
2504 | 1997-02-10 17:32:01
2505 | 1997-02-10 17:32:01
2506 | 1997-02-10 17:32:01
2507 | 1997-02-10 17:32:01
2508 | 1997-02-10 17:32:01
2509 | 1997-02-10 17:32:01
2510 | 1997-02-10 17:32:01
2511 | 1997-06-10 18:32:01
2512 | 1997-02-10 17:32:01
2513 | 1997-02-11 17:32:01
2514 | 1997-02-12 17:32:01
2515 | 1997-02-13 17:32:01
2516 | 1997-02-14 17:32:01
2517 | 1997-02-15 17:32:01
2518 | 1997-02-16 17:32:01
2519 | 0097-02-16 17:32:01 BC
2520 | 0097-02-16 17:32:01
2521 | 0597-02-16 17:32:01
2522 | 1097-02-16 17:32:01
2523 | 1697-02-16 17:32:01
2524 | 1797-02-16 17:32:01
2525 | 1897-02-16 17:32:01
2526 | 1997-02-16 17:32:01
2527 | 2097-02-16 17:32:01
2528 | 1996-02-28 17:32:01
2529 | 1996-02-29 17:32:01
2530 | 1996-03-01 17:32:01
2531 | 1996-12-30 17:32:01
2532 | 1996-12-31 17:32:01
2533 | 1997-01-01 17:32:01
2534 | 1997-02-28 17:32:01
2535 | 1997-03-01 17:32:01
2536 | 1997-12-30 17:32:01
2537 | 1997-12-31 17:32:01
2538 | 1999-12-31 17:32:01
2539 | 2000-01-01 17:32:01
2540 | 2000-12-31 17:32:01
2541 | 2001-01-01 17:32:01
2544 SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL;
2546 -------+------------------------
2547 | 1973-01-14 03:14:21-08
2548 | 1995-05-01 00:30:30-07
2549 | 1969-12-31 16:00:00-08
2552 | 1947-05-10 23:59:12-08
2556 SET DateStyle TO 'US,SQL';
2563 SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
2565 ----+------------------------
2568 | 01/01/1970 00:00:00
2569 | 02/10/1997 17:32:01
2570 | 02/10/1997 17:32:01
2571 | 02/10/1997 17:32:02
2572 | 02/10/1997 17:32:01.40
2573 | 02/10/1997 17:32:01.50
2574 | 02/10/1997 17:32:01.60
2575 | 01/02/1997 00:00:00
2576 | 01/02/1997 03:04:05
2577 | 02/10/1997 17:32:01
2578 | 02/10/1997 17:32:01
2579 | 02/10/1997 17:32:01
2580 | 02/10/1997 17:32:01
2581 | 06/10/1997 17:32:01
2582 | 09/22/2001 18:19:20
2583 | 03/15/2000 08:14:01
2584 | 03/15/2000 13:14:02
2585 | 03/15/2000 12:14:03
2586 | 03/15/2000 03:14:04
2587 | 03/15/2000 02:14:05
2588 | 02/10/1997 17:32:01
2589 | 02/10/1997 17:32:01
2590 | 02/10/1997 17:32:00
2591 | 02/10/1997 17:32:01
2592 | 02/10/1997 17:32:01
2593 | 02/10/1997 17:32:01
2594 | 02/10/1997 17:32:01
2595 | 02/10/1997 17:32:01
2596 | 02/10/1997 17:32:01
2597 | 02/10/1997 17:32:01
2598 | 02/10/1997 17:32:01
2599 | 06/10/1997 18:32:01
2600 | 02/10/1997 17:32:01
2601 | 02/11/1997 17:32:01
2602 | 02/12/1997 17:32:01
2603 | 02/13/1997 17:32:01
2604 | 02/14/1997 17:32:01
2605 | 02/15/1997 17:32:01
2606 | 02/16/1997 17:32:01
2607 | 02/16/0097 17:32:01 BC
2608 | 02/16/0097 17:32:01
2609 | 02/16/0597 17:32:01
2610 | 02/16/1097 17:32:01
2611 | 02/16/1697 17:32:01
2612 | 02/16/1797 17:32:01
2613 | 02/16/1897 17:32:01
2614 | 02/16/1997 17:32:01
2615 | 02/16/2097 17:32:01
2616 | 02/28/1996 17:32:01
2617 | 02/29/1996 17:32:01
2618 | 03/01/1996 17:32:01
2619 | 12/30/1996 17:32:01
2620 | 12/31/1996 17:32:01
2621 | 01/01/1997 17:32:01
2622 | 02/28/1997 17:32:01
2623 | 03/01/1997 17:32:01
2624 | 12/30/1997 17:32:01
2625 | 12/31/1997 17:32:01
2626 | 12/31/1999 17:32:01
2627 | 01/01/2000 17:32:01
2628 | 12/31/2000 17:32:01
2629 | 01/01/2001 17:32:01
2632 SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL;
2634 -------+-------------------------
2635 | 01/14/1973 03:14:21 PST
2636 | 05/01/1995 00:30:30 PDT
2637 | 12/31/1969 16:00:00 PST
2640 | 05/10/1947 23:59:12 PST
2644 SET DateStyle TO 'European,Postgres';
2647 --------------------
2651 INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957');
2652 SELECT count(*) as one FROM TIMESTAMP_TBL WHERE d1 = 'Jun 13 1957';
2658 SELECT '' AS "65", d1 AS european_postgres FROM TIMESTAMP_TBL;
2659 65 | european_postgres
2660 ----+-----------------------------
2663 | Thu 01 Jan 00:00:00 1970
2664 | Mon 10 Feb 17:32:01 1997
2665 | Mon 10 Feb 17:32:01 1997
2666 | Mon 10 Feb 17:32:02 1997
2667 | Mon 10 Feb 17:32:01.40 1997
2668 | Mon 10 Feb 17:32:01.50 1997
2669 | Mon 10 Feb 17:32:01.60 1997
2670 | Thu 02 Jan 00:00:00 1997
2671 | Thu 02 Jan 03:04:05 1997
2672 | Mon 10 Feb 17:32:01 1997
2673 | Mon 10 Feb 17:32:01 1997
2674 | Mon 10 Feb 17:32:01 1997
2675 | Mon 10 Feb 17:32:01 1997
2676 | Tue 10 Jun 17:32:01 1997
2677 | Sat 22 Sep 18:19:20 2001
2678 | Wed 15 Mar 08:14:01 2000
2679 | Wed 15 Mar 13:14:02 2000
2680 | Wed 15 Mar 12:14:03 2000
2681 | Wed 15 Mar 03:14:04 2000
2682 | Wed 15 Mar 02:14:05 2000
2683 | Mon 10 Feb 17:32:01 1997
2684 | Mon 10 Feb 17:32:01 1997
2685 | Mon 10 Feb 17:32:00 1997
2686 | Mon 10 Feb 17:32:01 1997
2687 | Mon 10 Feb 17:32:01 1997
2688 | Mon 10 Feb 17:32:01 1997
2689 | Mon 10 Feb 17:32:01 1997
2690 | Mon 10 Feb 17:32:01 1997
2691 | Mon 10 Feb 17:32:01 1997
2692 | Mon 10 Feb 17:32:01 1997
2693 | Mon 10 Feb 17:32:01 1997
2694 | Tue 10 Jun 18:32:01 1997
2695 | Mon 10 Feb 17:32:01 1997
2696 | Tue 11 Feb 17:32:01 1997
2697 | Wed 12 Feb 17:32:01 1997
2698 | Thu 13 Feb 17:32:01 1997
2699 | Fri 14 Feb 17:32:01 1997
2700 | Sat 15 Feb 17:32:01 1997
2701 | Sun 16 Feb 17:32:01 1997
2702 | Tue 16 Feb 17:32:01 0097 BC
2703 | Sat 16 Feb 17:32:01 0097
2704 | Thu 16 Feb 17:32:01 0597
2705 | Tue 16 Feb 17:32:01 1097
2706 | Sat 16 Feb 17:32:01 1697
2707 | Thu 16 Feb 17:32:01 1797
2708 | Tue 16 Feb 17:32:01 1897
2709 | Sun 16 Feb 17:32:01 1997
2710 | Sat 16 Feb 17:32:01 2097
2711 | Wed 28 Feb 17:32:01 1996
2712 | Thu 29 Feb 17:32:01 1996
2713 | Fri 01 Mar 17:32:01 1996
2714 | Mon 30 Dec 17:32:01 1996
2715 | Tue 31 Dec 17:32:01 1996
2716 | Wed 01 Jan 17:32:01 1997
2717 | Fri 28 Feb 17:32:01 1997
2718 | Sat 01 Mar 17:32:01 1997
2719 | Tue 30 Dec 17:32:01 1997
2720 | Wed 31 Dec 17:32:01 1997
2721 | Fri 31 Dec 17:32:01 1999
2722 | Sat 01 Jan 17:32:01 2000
2723 | Sun 31 Dec 17:32:01 2000
2724 | Mon 01 Jan 17:32:01 2001
2725 | Thu 13 Jun 00:00:00 1957
2728 SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL;
2729 seven | european_postgres
2730 -------+------------------------------
2731 | Sun 14 Jan 03:14:21 1973 PST
2732 | Mon 01 May 00:30:30 1995 PDT
2733 | Wed 31 Dec 16:00:00 1969 PST
2736 | Sat 10 May 23:59:12 1947 PST
2740 SET DateStyle TO 'European,ISO';
2747 SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL;
2749 ----+------------------------
2752 | 1970-01-01 00:00:00
2753 | 1997-02-10 17:32:01
2754 | 1997-02-10 17:32:01
2755 | 1997-02-10 17:32:02
2756 | 1997-02-10 17:32:01.40
2757 | 1997-02-10 17:32:01.50
2758 | 1997-02-10 17:32:01.60
2759 | 1997-01-02 00:00:00
2760 | 1997-01-02 03:04:05
2761 | 1997-02-10 17:32:01
2762 | 1997-02-10 17:32:01
2763 | 1997-02-10 17:32:01
2764 | 1997-02-10 17:32:01
2765 | 1997-06-10 17:32:01
2766 | 2001-09-22 18:19:20
2767 | 2000-03-15 08:14:01
2768 | 2000-03-15 13:14:02
2769 | 2000-03-15 12:14:03
2770 | 2000-03-15 03:14:04
2771 | 2000-03-15 02:14:05
2772 | 1997-02-10 17:32:01
2773 | 1997-02-10 17:32:01
2774 | 1997-02-10 17:32:00
2775 | 1997-02-10 17:32:01
2776 | 1997-02-10 17:32:01
2777 | 1997-02-10 17:32:01
2778 | 1997-02-10 17:32:01
2779 | 1997-02-10 17:32:01
2780 | 1997-02-10 17:32:01
2781 | 1997-02-10 17:32:01
2782 | 1997-02-10 17:32:01
2783 | 1997-06-10 18:32:01
2784 | 1997-02-10 17:32:01
2785 | 1997-02-11 17:32:01
2786 | 1997-02-12 17:32:01
2787 | 1997-02-13 17:32:01
2788 | 1997-02-14 17:32:01
2789 | 1997-02-15 17:32:01
2790 | 1997-02-16 17:32:01
2791 | 0097-02-16 17:32:01 BC
2792 | 0097-02-16 17:32:01
2793 | 0597-02-16 17:32:01
2794 | 1097-02-16 17:32:01
2795 | 1697-02-16 17:32:01
2796 | 1797-02-16 17:32:01
2797 | 1897-02-16 17:32:01
2798 | 1997-02-16 17:32:01
2799 | 2097-02-16 17:32:01
2800 | 1996-02-28 17:32:01
2801 | 1996-02-29 17:32:01
2802 | 1996-03-01 17:32:01
2803 | 1996-12-30 17:32:01
2804 | 1996-12-31 17:32:01
2805 | 1997-01-01 17:32:01
2806 | 1997-02-28 17:32:01
2807 | 1997-03-01 17:32:01
2808 | 1997-12-30 17:32:01
2809 | 1997-12-31 17:32:01
2810 | 1999-12-31 17:32:01
2811 | 2000-01-01 17:32:01
2812 | 2000-12-31 17:32:01
2813 | 2001-01-01 17:32:01
2814 | 1957-06-13 00:00:00
2817 SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL;
2818 seven | european_iso
2819 -------+------------------------
2820 | 1973-01-14 03:14:21-08
2821 | 1995-05-01 00:30:30-07
2822 | 1969-12-31 16:00:00-08
2825 | 1947-05-10 23:59:12-08
2829 SET DateStyle TO 'European,SQL';
2836 SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL;
2838 ----+------------------------
2841 | 01/01/1970 00:00:00
2842 | 10/02/1997 17:32:01
2843 | 10/02/1997 17:32:01
2844 | 10/02/1997 17:32:02
2845 | 10/02/1997 17:32:01.40
2846 | 10/02/1997 17:32:01.50
2847 | 10/02/1997 17:32:01.60
2848 | 02/01/1997 00:00:00
2849 | 02/01/1997 03:04:05
2850 | 10/02/1997 17:32:01
2851 | 10/02/1997 17:32:01
2852 | 10/02/1997 17:32:01
2853 | 10/02/1997 17:32:01
2854 | 10/06/1997 17:32:01
2855 | 22/09/2001 18:19:20
2856 | 15/03/2000 08:14:01
2857 | 15/03/2000 13:14:02
2858 | 15/03/2000 12:14:03
2859 | 15/03/2000 03:14:04
2860 | 15/03/2000 02:14:05
2861 | 10/02/1997 17:32:01
2862 | 10/02/1997 17:32:01
2863 | 10/02/1997 17:32:00
2864 | 10/02/1997 17:32:01
2865 | 10/02/1997 17:32:01
2866 | 10/02/1997 17:32:01
2867 | 10/02/1997 17:32:01
2868 | 10/02/1997 17:32:01
2869 | 10/02/1997 17:32:01
2870 | 10/02/1997 17:32:01
2871 | 10/02/1997 17:32:01
2872 | 10/06/1997 18:32:01
2873 | 10/02/1997 17:32:01
2874 | 11/02/1997 17:32:01
2875 | 12/02/1997 17:32:01
2876 | 13/02/1997 17:32:01
2877 | 14/02/1997 17:32:01
2878 | 15/02/1997 17:32:01
2879 | 16/02/1997 17:32:01
2880 | 16/02/0097 17:32:01 BC
2881 | 16/02/0097 17:32:01
2882 | 16/02/0597 17:32:01
2883 | 16/02/1097 17:32:01
2884 | 16/02/1697 17:32:01
2885 | 16/02/1797 17:32:01
2886 | 16/02/1897 17:32:01
2887 | 16/02/1997 17:32:01
2888 | 16/02/2097 17:32:01
2889 | 28/02/1996 17:32:01
2890 | 29/02/1996 17:32:01
2891 | 01/03/1996 17:32:01
2892 | 30/12/1996 17:32:01
2893 | 31/12/1996 17:32:01
2894 | 01/01/1997 17:32:01
2895 | 28/02/1997 17:32:01
2896 | 01/03/1997 17:32:01
2897 | 30/12/1997 17:32:01
2898 | 31/12/1997 17:32:01
2899 | 31/12/1999 17:32:01
2900 | 01/01/2000 17:32:01
2901 | 31/12/2000 17:32:01
2902 | 01/01/2001 17:32:01
2903 | 13/06/1957 00:00:00
2906 SELECT '' AS seven, f1 AS european_sql FROM ABSTIME_TBL;
2907 seven | european_sql
2908 -------+-------------------------
2909 | 14/01/1973 03:14:21 PST
2910 | 01/05/1995 00:30:30 PDT
2911 | 31/12/1969 16:00:00 PST
2914 | 10/05/1947 23:59:12 PST