Re: Re: Problem with Dates

From: Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz>
To: "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Re: Problem with Dates
Date: 2001-01-26 08:22:08
Message-ID: 01012621220800.13520@berty
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message John Reid 2001-01-26 08:31:25 Re: abstract data types?
Previous Message John Reid 2001-01-26 06:32:06 Re: abstract data types?