*** expected/datetime.out Thu Apr 15 08:02:44 1999 --- results/datetime.out Tue Jun 1 20:27:59 1999 *************** *** 227,232 **** --- 227,233 ---- WHERE d1 > '1997-01-02'::datetime and d1 != 'current'::datetime; fortythree|d1 ----------+------------------------------- + |-infinity |infinity |Mon Feb 10 17:32:01 1997 PST |Mon Feb 10 17:32:01.00 1997 PST *************** *** 269,281 **** |Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST ! (42 rows) QUERY: SELECT '' AS fifteen, d1 FROM DATETIME_TBL WHERE d1 < '1997-01-02'::datetime and d1 != 'current'::datetime; fifteen|d1 -------+---------------------------- - |-infinity |epoch |Tue Feb 16 17:32 0097 BC |Sat Feb 16 17:32:01 0097 --- 270,281 ---- |Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST ! (43 rows) QUERY: SELECT '' AS fifteen, d1 FROM DATETIME_TBL WHERE d1 < '1997-01-02'::datetime and d1 != 'current'::datetime; fifteen|d1 -------+---------------------------- |epoch |Tue Feb 16 17:32 0097 BC |Sat Feb 16 17:32:01 0097 *************** *** 290,296 **** |Mon Dec 30 17:32:01 1996 PST |Tue Dec 31 17:32:01 1996 PST |Wed Jan 01 17:32:01 1997 PST ! (15 rows) QUERY: SELECT '' AS one, d1 FROM DATETIME_TBL WHERE d1 = '1997-01-02'::datetime and d1 != 'current'::datetime; --- 290,296 ---- |Mon Dec 30 17:32:01 1996 PST |Tue Dec 31 17:32:01 1996 PST |Wed Jan 01 17:32:01 1997 PST ! (14 rows) QUERY: SELECT '' AS one, d1 FROM DATETIME_TBL WHERE d1 = '1997-01-02'::datetime and d1 != 'current'::datetime; *************** *** 366,372 **** WHERE d1 <= '1997-01-02'::datetime and d1 != 'current'::datetime; sixteen|d1 -------+---------------------------- - |-infinity |epoch |Thu Jan 02 00:00:00 1997 PST |Tue Feb 16 17:32 0097 BC --- 366,371 ---- *************** *** 382,393 **** |Mon Dec 30 17:32:01 1996 PST |Tue Dec 31 17:32:01 1996 PST |Wed Jan 01 17:32:01 1997 PST ! (16 rows) QUERY: SELECT '' AS fortyfour, d1 FROM DATETIME_TBL WHERE d1 >= '1997-01-02'::datetime and d1 != 'current'::datetime; fortyfour|d1 ---------+------------------------------- |infinity |Mon Feb 10 17:32:01 1997 PST |Mon Feb 10 17:32:01.00 1997 PST --- 381,393 ---- |Mon Dec 30 17:32:01 1996 PST |Tue Dec 31 17:32:01 1996 PST |Wed Jan 01 17:32:01 1997 PST ! (15 rows) QUERY: SELECT '' AS fortyfour, d1 FROM DATETIME_TBL WHERE d1 >= '1997-01-02'::datetime and d1 != 'current'::datetime; fortyfour|d1 ---------+------------------------------- + |-infinity |infinity |Mon Feb 10 17:32:01 1997 PST |Mon Feb 10 17:32:01.00 1997 PST *************** *** 431,437 **** |Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST ! (43 rows) QUERY: SELECT '' AS sixtythree, d1 + '1 year'::timespan AS one_year FROM DATETIME_TBL; sixtythree|one_year --- 431,437 ---- |Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST ! (44 rows) QUERY: SELECT '' AS sixtythree, d1 + '1 year'::timespan AS one_year FROM DATETIME_TBL; sixtythree|one_year *************** *** 569,574 **** --- 569,576 ---- FROM DATETIME_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; fifty|diff -----+-------------------------------------- + |@ 1093 days 16 hours + |@ 1093 days 16 hours |@ 9863 days 8 hours ago |@ 39 days 17 hours 32 mins 1 sec |@ 39 days 17 hours 32 mins 1.00 secs *************** *** 617,623 **** |@ 1094 days 17 hours 32 mins 1 sec |@ 1459 days 17 hours 32 mins 1 sec |@ 1460 days 17 hours 32 mins 1 sec ! (48 rows) QUERY: SELECT '' AS fortynine, date_part( 'year', d1) AS year, date_part( 'month', d1) AS month, date_part( 'day', d1) AS day, date_part( 'hour', d1) AS hour, --- 619,625 ---- |@ 1094 days 17 hours 32 mins 1 sec |@ 1459 days 17 hours 32 mins 1 sec |@ 1460 days 17 hours 32 mins 1 sec ! (50 rows) QUERY: SELECT '' AS fortynine, date_part( 'year', d1) AS year, date_part( 'month', d1) AS month, date_part( 'day', d1) AS day, date_part( 'hour', d1) AS hour, *************** *** 625,630 **** --- 627,634 ---- FROM DATETIME_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; fortynine|year|month|day|hour|minute| second ---------+----+-----+---+----+------+-------- + | 0| 0| 0| 0| 0| 0 + | 0| 0| 0| 0| 0| 0 |1969| 12| 31| 16| 0| 0 |1997| 2| 10| 17| 32| 1 |1997| 2| 10| 17| 32|1.000001 *************** *** 673,685 **** |2000| 1| 1| 17| 32| 1 |2000| 12| 31| 17| 32| 1 |2001| 1| 1| 17| 32| 1 ! (48 rows) QUERY: SELECT '' AS fortynine, date_part( 'quarter', d1) AS quarter, date_part( 'msec', d1) AS msec, date_part( 'usec', d1) AS usec FROM DATETIME_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; fortynine|quarter| msec| usec ---------+-------+--------------------+----------------- | 4| 0| 0 | 1| 0| 0 | 1|0.000999999999917733|0.999999999917733 --- 677,691 ---- |2000| 1| 1| 17| 32| 1 |2000| 12| 31| 17| 32| 1 |2001| 1| 1| 17| 32| 1 ! (50 rows) QUERY: SELECT '' AS fortynine, date_part( 'quarter', d1) AS quarter, date_part( 'msec', d1) AS msec, date_part( 'usec', d1) AS usec FROM DATETIME_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; fortynine|quarter| msec| usec ---------+-------+--------------------+----------------- + | 0| 0| 0 + | 0| 0| 0 | 4| 0| 0 | 1| 0| 0 | 1|0.000999999999917733|0.999999999917733 *************** *** 728,732 **** | 1| 0| 0 | 4| 0| 0 | 1| 0| 0 ! (48 rows) --- 734,738 ---- | 1| 0| 0 | 4| 0| 0 | 1| 0| 0 ! (50 rows) ---------------------- *** expected/horology.out Thu Apr 15 08:02:44 1999 --- results/horology.out Tue Jun 1 20:28:05 1999 *************** *** 14,24 **** |Fri Mar 01 17:32:01 1996 PST |Mon Dec 30 17:32:01 1996 PST |Tue Dec 31 17:32:01 1996 PST |Fri Dec 31 17:32:01 1999 PST |Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST ! (10 rows) QUERY: SELECT '' AS hundred, d.f1 AS datetime, t.f1 AS timespan, d.f1 + t.f1 AS plus FROM TEMP_DATETIME d, TIMESPAN_TBL t --- 14,26 ---- |Fri Mar 01 17:32:01 1996 PST |Mon Dec 30 17:32:01 1996 PST |Tue Dec 31 17:32:01 1996 PST + |-infinity + |infinity |Fri Dec 31 17:32:01 1999 PST |Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST ! (12 rows) QUERY: SELECT '' AS hundred, d.f1 AS datetime, t.f1 AS timespan, d.f1 + t.f1 AS plus FROM TEMP_DATETIME d, TIMESPAN_TBL t *************** *** 74,79 **** --- 76,101 ---- |Mon Dec 30 17:32:01 1996 PST|@ 5 mons 12 hours |Sat May 31 06:32:01 1997 PDT |Tue Dec 31 17:32:01 1996 PST|@ 5 mons |Sat May 31 18:32:01 1997 PDT |Tue Dec 31 17:32:01 1996 PST|@ 5 mons 12 hours |Sun Jun 01 06:32:01 1997 PDT + |-infinity |@ 14 secs ago |-infinity + |-infinity |@ 1 min |-infinity + |-infinity |@ 5 hours |-infinity + |-infinity |@ 1 day 2 hours 3 mins 4 secs|-infinity + |-infinity |@ 10 days |-infinity + |-infinity |@ 3 mons |-infinity + |-infinity |@ 5 mons |-infinity + |-infinity |@ 5 mons 12 hours |-infinity + |-infinity |@ 6 years |-infinity + |-infinity |@ 34 years |-infinity + |infinity |@ 14 secs ago |infinity + |infinity |@ 1 min |infinity + |infinity |@ 5 hours |infinity + |infinity |@ 1 day 2 hours 3 mins 4 secs|infinity + |infinity |@ 10 days |infinity + |infinity |@ 3 mons |infinity + |infinity |@ 5 mons |infinity + |infinity |@ 5 mons 12 hours |infinity + |infinity |@ 6 years |infinity + |infinity |@ 34 years |infinity |Fri Dec 31 17:32:01 1999 PST|@ 14 secs ago |Fri Dec 31 17:31:47 1999 PST |Fri Dec 31 17:32:01 1999 PST|@ 1 min |Fri Dec 31 17:33:01 1999 PST |Fri Dec 31 17:32:01 1999 PST|@ 5 hours |Fri Dec 31 22:32:01 1999 PST *************** *** 125,131 **** |Sat Jan 01 17:32:01 2000 PST|@ 34 years |Sun Jan 01 17:32:01 2034 PST |Sun Dec 31 17:32:01 2000 PST|@ 34 years |Sun Dec 31 17:32:01 2034 PST |Mon Jan 01 17:32:01 2001 PST|@ 34 years |Mon Jan 01 17:32:01 2035 PST ! (100 rows) QUERY: SELECT '' AS hundred, d.f1 AS datetime, t.f1 AS timespan, d.f1 - t.f1 AS minus FROM TEMP_DATETIME d, TIMESPAN_TBL t --- 147,153 ---- |Sat Jan 01 17:32:01 2000 PST|@ 34 years |Sun Jan 01 17:32:01 2034 PST |Sun Dec 31 17:32:01 2000 PST|@ 34 years |Sun Dec 31 17:32:01 2034 PST |Mon Jan 01 17:32:01 2001 PST|@ 34 years |Mon Jan 01 17:32:01 2035 PST ! (120 rows) QUERY: SELECT '' AS hundred, d.f1 AS datetime, t.f1 AS timespan, d.f1 - t.f1 AS minus FROM TEMP_DATETIME d, TIMESPAN_TBL t *************** *** 247,269 **** |Fri Mar 01 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 5900 days 1 hour 32 mins 1 sec |Mon Dec 30 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 6204 days 1 hour 32 mins 1 sec |Tue Dec 31 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 6205 days 1 hour 32 mins 1 sec |Fri Dec 31 17:32:01 1999 PST|Sat Jan 05 16:00:00 1980 PST|@ 7300 days 1 hour 32 mins 1 sec |Sat Jan 01 17:32:01 2000 PST|Sat Jan 05 16:00:00 1980 PST|@ 7301 days 1 hour 32 mins 1 sec |Sun Dec 31 17:32:01 2000 PST|Sat Jan 05 16:00:00 1980 PST|@ 7666 days 1 hour 32 mins 1 sec |Mon Jan 01 17:32:01 2001 PST|Sat Jan 05 16:00:00 1980 PST|@ 7667 days 1 hour 32 mins 1 sec ! (10 rows) QUERY: SELECT '' AS hundred, d1.f1 AS datetime1, d2.f1 AS datetime2, d1.f1 - d2.f1 AS difference FROM TEMP_DATETIME d1, TEMP_DATETIME d2 ORDER BY datetime1, datetime2, difference; hundred|datetime1 |datetime2 |difference ! -------+----------------------------+----------------------------+------------------------------------- |epoch |epoch |@ 0 |epoch |Wed Feb 28 17:32:01 1996 PST|@ 9555 days 1 hour 32 mins 1 sec ago |epoch |Thu Feb 29 17:32:01 1996 PST|@ 9556 days 1 hour 32 mins 1 sec ago |epoch |Fri Mar 01 17:32:01 1996 PST|@ 9557 days 1 hour 32 mins 1 sec ago |epoch |Mon Dec 30 17:32:01 1996 PST|@ 9861 days 1 hour 32 mins 1 sec ago |epoch |Tue Dec 31 17:32:01 1996 PST|@ 9862 days 1 hour 32 mins 1 sec ago |epoch |Fri Dec 31 17:32:01 1999 PST|@ 10957 days 1 hour 32 mins 1 sec ago |epoch |Sat Jan 01 17:32:01 2000 PST|@ 10958 days 1 hour 32 mins 1 sec ago |epoch |Sun Dec 31 17:32:01 2000 PST|@ 11323 days 1 hour 32 mins 1 sec ago --- 269,295 ---- |Fri Mar 01 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 5900 days 1 hour 32 mins 1 sec |Mon Dec 30 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 6204 days 1 hour 32 mins 1 sec |Tue Dec 31 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 6205 days 1 hour 32 mins 1 sec + |-infinity |Sat Jan 05 16:00:00 1980 PST|@ 7300 days + |infinity |Sat Jan 05 16:00:00 1980 PST|@ 7300 days |Fri Dec 31 17:32:01 1999 PST|Sat Jan 05 16:00:00 1980 PST|@ 7300 days 1 hour 32 mins 1 sec |Sat Jan 01 17:32:01 2000 PST|Sat Jan 05 16:00:00 1980 PST|@ 7301 days 1 hour 32 mins 1 sec |Sun Dec 31 17:32:01 2000 PST|Sat Jan 05 16:00:00 1980 PST|@ 7666 days 1 hour 32 mins 1 sec |Mon Jan 01 17:32:01 2001 PST|Sat Jan 05 16:00:00 1980 PST|@ 7667 days 1 hour 32 mins 1 sec ! (12 rows) QUERY: SELECT '' AS hundred, d1.f1 AS datetime1, d2.f1 AS datetime2, d1.f1 - d2.f1 AS difference FROM TEMP_DATETIME d1, TEMP_DATETIME d2 ORDER BY datetime1, datetime2, difference; hundred|datetime1 |datetime2 |difference ! -------+----------------------------+----------------------------+---------------------------------------- |epoch |epoch |@ 0 |epoch |Wed Feb 28 17:32:01 1996 PST|@ 9555 days 1 hour 32 mins 1 sec ago |epoch |Thu Feb 29 17:32:01 1996 PST|@ 9556 days 1 hour 32 mins 1 sec ago |epoch |Fri Mar 01 17:32:01 1996 PST|@ 9557 days 1 hour 32 mins 1 sec ago |epoch |Mon Dec 30 17:32:01 1996 PST|@ 9861 days 1 hour 32 mins 1 sec ago |epoch |Tue Dec 31 17:32:01 1996 PST|@ 9862 days 1 hour 32 mins 1 sec ago + |epoch |-infinity |@ 10957 days ago + |epoch |infinity |@ 10957 days ago |epoch |Fri Dec 31 17:32:01 1999 PST|@ 10957 days 1 hour 32 mins 1 sec ago |epoch |Sat Jan 01 17:32:01 2000 PST|@ 10958 days 1 hour 32 mins 1 sec ago |epoch |Sun Dec 31 17:32:01 2000 PST|@ 11323 days 1 hour 32 mins 1 sec ago *************** *** 274,279 **** --- 300,307 ---- |Wed Feb 28 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 2 days ago |Wed Feb 28 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 306 days ago |Wed Feb 28 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 307 days ago + |Wed Feb 28 17:32:01 1996 PST|-infinity |@ 1401 days 22 hours 27 mins 59 secs ago + |Wed Feb 28 17:32:01 1996 PST|infinity |@ 1401 days 22 hours 27 mins 59 secs ago |Wed Feb 28 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1402 days ago |Wed Feb 28 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1403 days ago |Wed Feb 28 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1768 days ago *************** *** 284,289 **** --- 312,319 ---- |Thu Feb 29 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 1 day ago |Thu Feb 29 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 305 days ago |Thu Feb 29 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 306 days ago + |Thu Feb 29 17:32:01 1996 PST|-infinity |@ 1400 days 22 hours 27 mins 59 secs ago + |Thu Feb 29 17:32:01 1996 PST|infinity |@ 1400 days 22 hours 27 mins 59 secs ago |Thu Feb 29 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1401 days ago |Thu Feb 29 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1402 days ago |Thu Feb 29 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1767 days ago *************** *** 294,299 **** --- 324,331 ---- |Fri Mar 01 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 0 |Fri Mar 01 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 304 days ago |Fri Mar 01 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 305 days ago + |Fri Mar 01 17:32:01 1996 PST|-infinity |@ 1399 days 22 hours 27 mins 59 secs ago + |Fri Mar 01 17:32:01 1996 PST|infinity |@ 1399 days 22 hours 27 mins 59 secs ago |Fri Mar 01 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1400 days ago |Fri Mar 01 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1401 days ago |Fri Mar 01 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1766 days ago *************** *** 304,309 **** --- 336,343 ---- |Mon Dec 30 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 304 days |Mon Dec 30 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 0 |Mon Dec 30 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 1 day ago + |Mon Dec 30 17:32:01 1996 PST|-infinity |@ 1095 days 22 hours 27 mins 59 secs ago + |Mon Dec 30 17:32:01 1996 PST|infinity |@ 1095 days 22 hours 27 mins 59 secs ago |Mon Dec 30 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1096 days ago |Mon Dec 30 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1097 days ago |Mon Dec 30 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1462 days ago *************** *** 314,329 **** --- 348,391 ---- |Tue Dec 31 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 305 days |Tue Dec 31 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 1 day |Tue Dec 31 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 0 + |Tue Dec 31 17:32:01 1996 PST|-infinity |@ 1094 days 22 hours 27 mins 59 secs ago + |Tue Dec 31 17:32:01 1996 PST|infinity |@ 1094 days 22 hours 27 mins 59 secs ago |Tue Dec 31 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1095 days ago |Tue Dec 31 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1096 days ago |Tue Dec 31 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1461 days ago |Tue Dec 31 17:32:01 1996 PST|Mon Jan 01 17:32:01 2001 PST|@ 1462 days ago + |-infinity |epoch |@ 10957 days + |-infinity |Wed Feb 28 17:32:01 1996 PST|@ 1401 days 22 hours 27 mins 59 secs + |-infinity |Thu Feb 29 17:32:01 1996 PST|@ 1400 days 22 hours 27 mins 59 secs + |-infinity |Fri Mar 01 17:32:01 1996 PST|@ 1399 days 22 hours 27 mins 59 secs + |-infinity |Mon Dec 30 17:32:01 1996 PST|@ 1095 days 22 hours 27 mins 59 secs + |-infinity |Tue Dec 31 17:32:01 1996 PST|@ 1094 days 22 hours 27 mins 59 secs + |-infinity |-infinity |@ 0 + |-infinity |infinity |@ 0 + |-infinity |Fri Dec 31 17:32:01 1999 PST|@ 1 hour 32 mins 1 sec ago + |-infinity |Sat Jan 01 17:32:01 2000 PST|@ 1 day 1 hour 32 mins 1 sec ago + |-infinity |Sun Dec 31 17:32:01 2000 PST|@ 366 days 1 hour 32 mins 1 sec ago + |-infinity |Mon Jan 01 17:32:01 2001 PST|@ 367 days 1 hour 32 mins 1 sec ago + |infinity |epoch |@ 10957 days + |infinity |Wed Feb 28 17:32:01 1996 PST|@ 1401 days 22 hours 27 mins 59 secs + |infinity |Thu Feb 29 17:32:01 1996 PST|@ 1400 days 22 hours 27 mins 59 secs + |infinity |Fri Mar 01 17:32:01 1996 PST|@ 1399 days 22 hours 27 mins 59 secs + |infinity |Mon Dec 30 17:32:01 1996 PST|@ 1095 days 22 hours 27 mins 59 secs + |infinity |Tue Dec 31 17:32:01 1996 PST|@ 1094 days 22 hours 27 mins 59 secs + |infinity |-infinity |@ 0 + |infinity |infinity |@ 0 + |infinity |Fri Dec 31 17:32:01 1999 PST|@ 1 hour 32 mins 1 sec ago + |infinity |Sat Jan 01 17:32:01 2000 PST|@ 1 day 1 hour 32 mins 1 sec ago + |infinity |Sun Dec 31 17:32:01 2000 PST|@ 366 days 1 hour 32 mins 1 sec ago + |infinity |Mon Jan 01 17:32:01 2001 PST|@ 367 days 1 hour 32 mins 1 sec ago |Fri Dec 31 17:32:01 1999 PST|epoch |@ 10957 days 1 hour 32 mins 1 sec |Fri Dec 31 17:32:01 1999 PST|Wed Feb 28 17:32:01 1996 PST|@ 1402 days |Fri Dec 31 17:32:01 1999 PST|Thu Feb 29 17:32:01 1996 PST|@ 1401 days |Fri Dec 31 17:32:01 1999 PST|Fri Mar 01 17:32:01 1996 PST|@ 1400 days |Fri Dec 31 17:32:01 1999 PST|Mon Dec 30 17:32:01 1996 PST|@ 1096 days |Fri Dec 31 17:32:01 1999 PST|Tue Dec 31 17:32:01 1996 PST|@ 1095 days + |Fri Dec 31 17:32:01 1999 PST|-infinity |@ 1 hour 32 mins 1 sec + |Fri Dec 31 17:32:01 1999 PST|infinity |@ 1 hour 32 mins 1 sec |Fri Dec 31 17:32:01 1999 PST|Fri Dec 31 17:32:01 1999 PST|@ 0 |Fri Dec 31 17:32:01 1999 PST|Sat Jan 01 17:32:01 2000 PST|@ 1 day ago |Fri Dec 31 17:32:01 1999 PST|Sun Dec 31 17:32:01 2000 PST|@ 366 days ago *************** *** 334,339 **** --- 396,403 ---- |Sat Jan 01 17:32:01 2000 PST|Fri Mar 01 17:32:01 1996 PST|@ 1401 days |Sat Jan 01 17:32:01 2000 PST|Mon Dec 30 17:32:01 1996 PST|@ 1097 days |Sat Jan 01 17:32:01 2000 PST|Tue Dec 31 17:32:01 1996 PST|@ 1096 days + |Sat Jan 01 17:32:01 2000 PST|-infinity |@ 1 day 1 hour 32 mins 1 sec + |Sat Jan 01 17:32:01 2000 PST|infinity |@ 1 day 1 hour 32 mins 1 sec |Sat Jan 01 17:32:01 2000 PST|Fri Dec 31 17:32:01 1999 PST|@ 1 day |Sat Jan 01 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST|@ 0 |Sat Jan 01 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST|@ 365 days ago *************** *** 344,349 **** --- 408,415 ---- |Sun Dec 31 17:32:01 2000 PST|Fri Mar 01 17:32:01 1996 PST|@ 1766 days |Sun Dec 31 17:32:01 2000 PST|Mon Dec 30 17:32:01 1996 PST|@ 1462 days |Sun Dec 31 17:32:01 2000 PST|Tue Dec 31 17:32:01 1996 PST|@ 1461 days + |Sun Dec 31 17:32:01 2000 PST|-infinity |@ 366 days 1 hour 32 mins 1 sec + |Sun Dec 31 17:32:01 2000 PST|infinity |@ 366 days 1 hour 32 mins 1 sec |Sun Dec 31 17:32:01 2000 PST|Fri Dec 31 17:32:01 1999 PST|@ 366 days |Sun Dec 31 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST|@ 365 days |Sun Dec 31 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST|@ 0 *************** *** 354,364 **** |Mon Jan 01 17:32:01 2001 PST|Fri Mar 01 17:32:01 1996 PST|@ 1767 days |Mon Jan 01 17:32:01 2001 PST|Mon Dec 30 17:32:01 1996 PST|@ 1463 days |Mon Jan 01 17:32:01 2001 PST|Tue Dec 31 17:32:01 1996 PST|@ 1462 days |Mon Jan 01 17:32:01 2001 PST|Fri Dec 31 17:32:01 1999 PST|@ 367 days |Mon Jan 01 17:32:01 2001 PST|Sat Jan 01 17:32:01 2000 PST|@ 366 days |Mon Jan 01 17:32:01 2001 PST|Sun Dec 31 17:32:01 2000 PST|@ 1 day |Mon Jan 01 17:32:01 2001 PST|Mon Jan 01 17:32:01 2001 PST|@ 0 ! (100 rows) QUERY: SELECT '' as fifty, d1 as datetime, date_part('year', d1) AS year, date_part('month', d1) AS month, --- 420,432 ---- |Mon Jan 01 17:32:01 2001 PST|Fri Mar 01 17:32:01 1996 PST|@ 1767 days |Mon Jan 01 17:32:01 2001 PST|Mon Dec 30 17:32:01 1996 PST|@ 1463 days |Mon Jan 01 17:32:01 2001 PST|Tue Dec 31 17:32:01 1996 PST|@ 1462 days + |Mon Jan 01 17:32:01 2001 PST|-infinity |@ 367 days 1 hour 32 mins 1 sec + |Mon Jan 01 17:32:01 2001 PST|infinity |@ 367 days 1 hour 32 mins 1 sec |Mon Jan 01 17:32:01 2001 PST|Fri Dec 31 17:32:01 1999 PST|@ 367 days |Mon Jan 01 17:32:01 2001 PST|Sat Jan 01 17:32:01 2000 PST|@ 366 days |Mon Jan 01 17:32:01 2001 PST|Sun Dec 31 17:32:01 2000 PST|@ 1 day |Mon Jan 01 17:32:01 2001 PST|Mon Jan 01 17:32:01 2001 PST|@ 0 ! (144 rows) QUERY: SELECT '' as fifty, d1 as datetime, date_part('year', d1) AS year, date_part('month', d1) AS month, *************** *** 439,463 **** FROM TEMP_DATETIME WHERE f1 <> 'current'::datetime ORDER BY date; ! ten|datetime | date ! ---+----------------------------+---------- ! |epoch |01-01-1970 ! |Wed Feb 28 17:32:01 1996 PST|02-28-1996 ! |Thu Feb 29 17:32:01 1996 PST|02-29-1996 ! |Fri Mar 01 17:32:01 1996 PST|03-01-1996 ! |Mon Dec 30 17:32:01 1996 PST|12-30-1996 ! |Tue Dec 31 17:32:01 1996 PST|12-31-1996 ! |Fri Dec 31 17:32:01 1999 PST|12-31-1999 ! |Sat Jan 01 17:32:01 2000 PST|01-01-2000 ! |Sun Dec 31 17:32:01 2000 PST|12-31-2000 ! |Mon Jan 01 17:32:01 2001 PST|01-01-2001 ! (10 rows) ! QUERY: SELECT '' AS ten, f1 AS datetime, abstime( f1) AS abstime FROM TEMP_DATETIME ORDER BY abstime; ten|datetime |abstime ---+----------------------------+---------------------------- |epoch |epoch |Wed Feb 28 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST |Thu Feb 29 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST --- 507,519 ---- FROM TEMP_DATETIME WHERE f1 <> 'current'::datetime ORDER BY date; ! ERROR: Unable to convert datetime to date QUERY: SELECT '' AS ten, f1 AS datetime, abstime( f1) AS abstime FROM TEMP_DATETIME ORDER BY abstime; ten|datetime |abstime ---+----------------------------+---------------------------- + |-infinity |-infinity |epoch |epoch |Wed Feb 28 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST |Thu Feb 29 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST *************** *** 468,474 **** |Sat Jan 01 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST|Mon Jan 01 17:32:01 2001 PST ! (10 rows) QUERY: SELECT '' AS five, f1 AS abstime, date( f1) AS date FROM ABSTIME_TBL --- 524,531 ---- |Sat Jan 01 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST |Sun Dec 31 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST |Mon Jan 01 17:32:01 2001 PST|Mon Jan 01 17:32:01 2001 PST ! |infinity |infinity ! (12 rows) QUERY: SELECT '' AS five, f1 AS abstime, date( f1) AS date FROM ABSTIME_TBL ----------------------