Re: Problem with Dates

From: "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz>
To: "Mike Castle" <dalgoda(at)ix(dot)netcom(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem with Dates
Date: 2001-01-25 02:06:38
Message-ID: 003f01c08673$75d617e0$0101a8c0@godzone.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

pressie# select '31/12/2000'::date + '1 year'::timespan;
?column?
-----------------------------
01/01/2002 00:00:00.00 NZDT
(1 row)

pressie=#

Well I do :-(

I vaguely remember someone else having the same problem and it was
something to do with daylight saving. I don't recall the solution
though, if there was one.

Glen.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Castle 2001-01-25 02:17:31 Re: Problem with Dates
Previous Message Jan Wieck 2001-01-24 23:00:03 Re: Rules and transactions