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 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 <<--