Re: Re: Problem with Dates

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 Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ xtra . co . nz
CNOTES 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 <<--