On Fri, 26 Jan 2001 12:46, Glen and Rosanne Eustace wrote:
[ ... ]
> template1=# select '31/12/2000'::date + '365 days'::timespan;
> ?column?
> ------------------------
> 2002-01-01 00:00:00+13 <<<<<<<<<<< Wrong
> (1 row)
[ ... ]
I get the same result. This business of crooked dates in NZ summertime
is frequently because the rest of the world can't twig on to the notion that
it is possible to have GMT + 13, and do not take account of it in date/time
calculations.
--
Sincerely etc.,
NAME Christopher SawtellCELL PHONE 021 257 4451ICQ UIN 45863470EMAIL csawtell @ xtra . co . nzCNOTES
ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-->> Please refrain from using HTML or WORD attachments in e-mails to me <<--