Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with Dates - Mailing list pgsql-sql

From Glen and Rosanne Eustace
Subject Re: Problem with Dates
Date
Msg-id 003f01c08673$75d617e0$0101a8c0@godzone.net.nz
Whole thread Raw
In response to Problem with Dates  ("Glen and Rosanne Eustace" <agree@godzone.net.nz>)
Responses Re: Problem with Dates  (Mike Castle <dalgoda@ix.netcom.com>)
Re: Re: Problem with Dates  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Rules and transactions
Next
From: Mike Castle
Date:
Subject: Re: Problem with Dates