If the year is very large, datetime formatting overflows its limits and
gives very weird results. Either the formatting needs to be improved
or there should be an upper bound on the year.
bray=# select version(); version
------------------------------------------------------------------PostgreSQL 7.1beta1 on i686-pc-linux-gnu, compiled by
GCC2.95.3
(1 row)
bray=# select 'now'::datetime + '100000y'::interval; ?column?
---------------------102001-01-13 22:128
(1 row)
bray=# select 'now'::datetime + '1000000y'::interval; ?column?
---------------------1002001-01-13 22:32
(1 row)
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
======================================== "Wherefore let him that thinketh he standeth take heed lest he fall."
I Corinthians 10:12
