*** ./expected/horology.out Fri Feb 21 16:28:17 2003 --- ./results/horology.out Fri Feb 21 21:54:15 2003 *************** *** 329,355 **** (1 row) SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '1000000000 days' AS "Nov 27, 2733194"; ! Nov 27, 2733194 ! ----------------------------- ! Sun Nov 27 00:00:00 2733194 ! (1 row) ! SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '2000000000 days' AS "Nov 30, 5471101"; Nov 30, 5471101 ! ----------------------------- ! Sat Nov 30 00:00:00 5471101 (1 row) SELECT timestamp without time zone 'Nov 25, 4714 BC' + interval '2147483492 days' AS "Dec 31, 5874897"; Dec 31, 5874897 ! ----------------------------- ! Tue Dec 31 00:00:00 5874897 (1 row) SELECT timestamp without time zone '12/31/5874897' - timestamp without time zone 'Nov 24, 4714 BC' AS "2147483493 Days"; 2147483493 Days ! ------------------- ! @ 2147483493 days (1 row) -- Shorthand values --- 329,351 ---- (1 row) SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '1000000000 days' AS "Nov 27, 2733194"; ! ERROR: Unable to format timestamp; internal coding error SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '2000000000 days' AS "Nov 30, 5471101"; Nov 30, 5471101 ! ----------------------------------- ! Thu Jun 20 23:43:34.035456 210115 (1 row) SELECT timestamp without time zone 'Nov 25, 4714 BC' + interval '2147483492 days' AS "Dec 31, 5874897"; Dec 31, 5874897 ! --------------------------------- ! Mon Jul 04 15:41:44.48384 29357 (1 row) SELECT timestamp without time zone '12/31/5874897' - timestamp without time zone 'Nov 24, 4714 BC' AS "2147483493 Days"; 2147483493 Days ! --------------------------------------------- ! @ 12443669 days 15 hours 41 mins 44.48 secs (1 row) -- Shorthand values ======================================================================