interval madness ... - Mailing list pgsql-hackers

test=# select now() + '3 years 2 decades 4000 seconds 9 minutes'::interval;

           ?column?            

-------------------------------

 2031-06-28 11:58:35.052423+02

(1 row)

test=# select now() + '3 years 2 decades 4000 seconds 9 minutes 1 century'::interval;

           ?column?            

-------------------------------

 2131-06-28 11:59:01.635835+01

(1 row)

why do i get a different timezone just because of adding one more century?

i cannot see an obvious reason.

many thanks,

hans