*** ./expected/abstime.out Wed Nov 21 19:27:25 2001 --- ./results/abstime.out Thu May 9 17:27:00 2002 *************** *** 44,50 **** | Wed Dec 31 16:00:00 1969 PST | infinity | -infinity ! | Sat May 10 23:59:12 1947 PST | invalid (7 rows) --- 44,50 ---- | Wed Dec 31 16:00:00 1969 PST | infinity | -infinity ! | Sat May 10 15:59:12 1947 PST | invalid (7 rows) *************** *** 56,62 **** | Mon May 01 00:30:30 1995 PDT | Wed Dec 31 16:00:00 1969 PST | -infinity ! | Sat May 10 23:59:12 1947 PST (5 rows) SELECT '' AS six, ABSTIME_TBL.* --- 56,62 ---- | Mon May 01 00:30:30 1995 PDT | Wed Dec 31 16:00:00 1969 PST | -infinity ! | Sat May 10 15:59:12 1947 PST (5 rows) SELECT '' AS six, ABSTIME_TBL.* *************** *** 67,73 **** | Mon May 01 00:30:30 1995 PDT | Wed Dec 31 16:00:00 1969 PST | infinity ! | Sat May 10 23:59:12 1947 PST | invalid (6 rows) --- 67,73 ---- | Mon May 01 00:30:30 1995 PDT | Wed Dec 31 16:00:00 1969 PST | infinity ! | Sat May 10 15:59:12 1947 PST | invalid (6 rows) *************** *** 89,95 **** -------+------------------------------ | Wed Dec 31 16:00:00 1969 PST | -infinity ! | Sat May 10 23:59:12 1947 PST (3 rows) SELECT '' AS four, ABSTIME_TBL.* --- 89,95 ---- -------+------------------------------ | Wed Dec 31 16:00:00 1969 PST | -infinity ! | Sat May 10 15:59:12 1947 PST (3 rows) SELECT '' AS four, ABSTIME_TBL.* *************** *** 99,105 **** | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST | -infinity ! | Sat May 10 23:59:12 1947 PST (4 rows) SELECT '' AS four, ABSTIME_TBL.* --- 99,105 ---- | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST | -infinity ! | Sat May 10 15:59:12 1947 PST (4 rows) SELECT '' AS four, ABSTIME_TBL.* *************** *** 121,127 **** ORDER BY abstime; four | abstime | year | month | day | hour | minute | second ------+------------------------------+------+-------+-----+------+--------+-------- ! | Sat May 10 23:59:12 1947 PST | 1947 | 5 | 10 | 23 | 59 | 12 | Wed Dec 31 16:00:00 1969 PST | 1969 | 12 | 31 | 16 | 0 | 0 | Sun Jan 14 03:14:21 1973 PST | 1973 | 1 | 14 | 3 | 14 | 21 | Mon May 01 00:30:30 1995 PDT | 1995 | 5 | 1 | 0 | 30 | 30 --- 121,127 ---- ORDER BY abstime; four | abstime | year | month | day | hour | minute | second ------+------------------------------+------+-------+-----+------+--------+-------- ! | Sat May 10 15:59:12 1947 PST | 1947 | 5 | 10 | 15 | 59 | 12 | Wed Dec 31 16:00:00 1969 PST | 1969 | 12 | 31 | 16 | 0 | 0 | Sun Jan 14 03:14:21 1973 PST | 1973 | 1 | 14 | 3 | 14 | 21 | Mon May 01 00:30:30 1995 PDT | 1995 | 5 | 1 | 0 | 30 | 30 ====================================================================== *** ./expected/tinterval.out Fri Sep 28 09:59:53 2001 --- ./results/tinterval.out Thu May 9 17:27:00 2002 *************** *** 26,32 **** five | f1 ------+----------------------------------------------------------------- | ["-infinity" "infinity"] ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] --- 26,32 ---- five | f1 ------+----------------------------------------------------------------- | ["-infinity" "infinity"] ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] *************** *** 47,53 **** WHERE t.f1 #<> '@ 1 months'; three | f1 -------+----------------------------------------------------------------- ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] (3 rows) --- 47,53 ---- WHERE t.f1 #<> '@ 1 months'; three | f1 -------+----------------------------------------------------------------- ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] (3 rows) *************** *** 75,81 **** WHERE t.f1 #> '@ 1 year'; three | f1 -------+----------------------------------------------------------------- ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] (3 rows) --- 75,81 ---- WHERE t.f1 #> '@ 1 year'; three | f1 -------+----------------------------------------------------------------- ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] (3 rows) *************** *** 86,92 **** WHERE t.f1 #>= '@ 3 years'; three | f1 -------+----------------------------------------------------------------- ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] (3 rows) --- 86,92 ---- WHERE t.f1 #>= '@ 3 years'; three | f1 -------+----------------------------------------------------------------- ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] (3 rows) *************** *** 115,121 **** | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] (5 rows) SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2 --- 115,121 ---- | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] (5 rows) SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2 *************** *** 127,133 **** | ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] ! | ["-infinity" "infinity"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"] --- 127,133 ---- | ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] ! | ["-infinity" "infinity"] | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"] *************** *** 135,143 **** | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] ! | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["-infinity" "infinity"] ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] (14 rows) -- contains --- 135,143 ---- | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] ! | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["-infinity" "infinity"] ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] (14 rows) -- contains *************** *** 150,156 **** ------+----------------------------------------------------------------- | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] ! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] (3 rows) -- make time interval --- 150,156 ---- ------+----------------------------------------------------------------- | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] ! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] (3 rows) -- make time interval ====================================================================== *** ./expected/horology.out Sat Jan 12 05:38:34 2002 --- ./results/horology.out Thu May 9 17:27:01 2002 *************** *** 652,658 **** ----+--------------------------------- | -infinity | infinity ! | Tue Dec 31 16:00:00 1968 PST | Sat Feb 10 17:32:01 1996 PST | Sat Feb 10 17:32:01 1996 PST | Sat Feb 10 17:32:02 1996 PST --- 652,658 ---- ----+--------------------------------- | -infinity | infinity ! | Tue Dec 31 08:00:00 1968 PST | Sat Feb 10 17:32:01 1996 PST | Sat Feb 10 17:32:01 1996 PST | Sat Feb 10 17:32:02 1996 PST *************** *** 1721,1746 **** ORDER BY minus, "timestamp", "interval"; 160 | timestamp | interval | minus -----+------------------------------+-------------------------------+------------------------------ ! | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Wed Jan 01 00:00:00 1936 PST ! | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST ! | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST ! | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 17:32:01 1962 PST ! | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 17:32:01 1962 PST ! | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 17:32:01 1962 PST ! | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Wed Jan 01 00:00:00 1964 PST ! | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 17:32:01 1965 PST ! | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 17:32:01 1966 PST ! | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Tue Mar 15 02:14:05 1966 PST ! | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Tue Mar 15 03:14:04 1966 PST ! | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 08:14:01 1966 PST ! | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Tue Mar 15 12:14:03 1966 PST ! | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 13:14:02 1966 PST ! | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST ! | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST ! | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 18:19:20 1967 PDT ! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 12:00:00 1969 PDT ! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Fri Aug 01 00:00:00 1969 PDT ! | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Oct 01 00:00:00 1969 PDT | Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST | Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST --- 1721,1746 ---- ORDER BY minus, "timestamp", "interval"; 160 | timestamp | interval | minus -----+------------------------------+-------------------------------+------------------------------ ! | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Tue Dec 31 16:00:00 1935 PST ! | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 09:32:01 1962 PST ! | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 09:32:01 1962 PST ! | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 09:32:01 1962 PST ! | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 09:32:01 1962 PST ! | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 09:32:01 1962 PST ! | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Tue Dec 31 16:00:00 1963 PST ! | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 09:32:01 1965 PST ! | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 09:32:01 1966 PST ! | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Mon Mar 14 18:14:05 1966 PST ! | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Mon Mar 14 19:14:04 1966 PST ! | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 00:14:01 1966 PST ! | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Tue Mar 15 04:14:03 1966 PST ! | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 05:14:02 1966 PST ! | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 09:32:01 1966 PST ! | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 09:32:01 1967 PST ! | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 11:19:20 1967 PDT ! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 05:00:00 1969 PDT ! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Thu Jul 31 17:00:00 1969 PDT ! | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Tue Sep 30 17:00:00 1969 PDT | Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST | Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST *************** *** 2178,2188 **** ORDER BY abstime, reltime; ten | abstime | reltime -----+------------------------------+--------------- ! | Sat May 10 23:59:12 1947 PST | @ 14 secs ago ! | Sat May 10 23:59:12 1947 PST | @ 1 min ! | Sat May 10 23:59:12 1947 PST | @ 5 hours ! | Sat May 10 23:59:12 1947 PST | @ 10 days ! | Sat May 10 23:59:12 1947 PST | @ 3 mons | Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago | Wed Dec 31 16:00:00 1969 PST | @ 1 min | Wed Dec 31 16:00:00 1969 PST | @ 5 hours --- 2178,2188 ---- ORDER BY abstime, reltime; ten | abstime | reltime -----+------------------------------+--------------- ! | Sat May 10 15:59:12 1947 PST | @ 14 secs ago ! | Sat May 10 15:59:12 1947 PST | @ 1 min ! | Sat May 10 15:59:12 1947 PST | @ 5 hours ! | Sat May 10 15:59:12 1947 PST | @ 10 days ! | Sat May 10 15:59:12 1947 PST | @ 3 mons | Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago | Wed Dec 31 16:00:00 1969 PST | @ 1 min | Wed Dec 31 16:00:00 1969 PST | @ 5 hours *************** *** 2200,2206 **** -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 23:59:12 1947 PST (3 rows) SELECT '' AS three, ABSTIME_TBL.* --- 2200,2206 ---- -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 15:59:12 1947 PST (3 rows) SELECT '' AS three, ABSTIME_TBL.* *************** *** 2210,2216 **** -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 23:59:12 1947 PST (3 rows) SELECT '' AS three, ABSTIME_TBL.* --- 2210,2216 ---- -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 15:59:12 1947 PST (3 rows) SELECT '' AS three, ABSTIME_TBL.* *************** *** 2220,2226 **** -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 23:59:12 1947 PST (3 rows) SELECT '' AS three, ABSTIME_TBL.* --- 2220,2226 ---- -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 15:59:12 1947 PST (3 rows) SELECT '' AS three, ABSTIME_TBL.* *************** *** 2230,2236 **** -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 23:59:12 1947 PST (3 rows) -- --- 2230,2236 ---- -------+------------------------------ | Sun Jan 14 03:14:21 1973 PST | Wed Dec 31 16:00:00 1969 PST ! | Sat May 10 15:59:12 1947 PST (3 rows) -- *************** *** 2289,2295 **** ORDER BY date, abstime; four | abstime | date ------+------------------------------+------------ ! | Sat May 10 23:59:12 1947 PST | 05-10-1947 | Wed Dec 31 16:00:00 1969 PST | 12-31-1969 | Sun Jan 14 03:14:21 1973 PST | 01-14-1973 | Mon May 01 00:30:30 1995 PDT | 05-01-1995 --- 2289,2295 ---- ORDER BY date, abstime; four | abstime | date ------+------------------------------+------------ ! | Sat May 10 15:59:12 1947 PST | 05-10-1947 | Wed Dec 31 16:00:00 1969 PST | 12-31-1969 | Sun Jan 14 03:14:21 1973 PST | 01-14-1973 | Mon May 01 00:30:30 1995 PDT | 05-01-1995 *************** *** 2418,2424 **** | Wed Dec 31 16:00:00 1969 PST | infinity | -infinity ! | Sat May 10 23:59:12 1947 PST | invalid (7 rows) --- 2418,2424 ---- | Wed Dec 31 16:00:00 1969 PST | infinity | -infinity ! | Sat May 10 15:59:12 1947 PST | invalid (7 rows) *************** *** 2500,2506 **** | 1969-12-31 16:00:00-08 | infinity | -infinity ! | 1947-05-10 23:59:12-08 | invalid (7 rows) --- 2500,2506 ---- | 1969-12-31 16:00:00-08 | infinity | -infinity ! | 1947-05-10 15:59:12-08 | invalid (7 rows) *************** *** 2584,2590 **** | 12/31/1969 16:00:00 PST | infinity | -infinity ! | 05/10/1947 23:59:12 PST | invalid (7 rows) --- 2584,2590 ---- | 12/31/1969 16:00:00 PST | infinity | -infinity ! | 05/10/1947 15:59:12 PST | invalid (7 rows) *************** *** 2676,2682 **** | Wed 31 Dec 16:00:00 1969 PST | infinity | -infinity ! | Sat 10 May 23:59:12 1947 PST | invalid (7 rows) --- 2676,2682 ---- | Wed 31 Dec 16:00:00 1969 PST | infinity | -infinity ! | Sat 10 May 15:59:12 1947 PST | invalid (7 rows) *************** *** 2761,2767 **** | 1969-12-31 16:00:00-08 | infinity | -infinity ! | 1947-05-10 23:59:12-08 | invalid (7 rows) --- 2761,2767 ---- | 1969-12-31 16:00:00-08 | infinity | -infinity ! | 1947-05-10 15:59:12-08 | invalid (7 rows) *************** *** 2846,2852 **** | 31/12/1969 16:00:00 PST | infinity | -infinity ! | 10/05/1947 23:59:12 PST | invalid (7 rows) --- 2846,2852 ---- | 31/12/1969 16:00:00 PST | infinity | -infinity ! | 10/05/1947 15:59:12 PST | invalid (7 rows) ======================================================================