Re: timestamp bug - Mailing list pgsql-sql

From Richard Huxton
Subject Re: timestamp bug
Date
Msg-id 3B07B8C2.CD8A43EA@archonet.com
Whole thread Raw
In response to timestamp bug  (Cedar Cox <cedarc@visionforisrael.com>)
Responses Re: timestamp bug
List pgsql-sql
Cedar Cox wrote:
> 
> There appears to be a bug in timestamp/interval addition.  It happens in
> both PG version 7.0.2 and 7.1.  There is a duplicate day (2001 Sep 07) and
> a missing day (2002 Apr 04).  I discovered this by accident when I asked
> the interface I'm writing for a 365 day long calendar..  Interestingly,
> the missing day thing (second example) doesn't happen if only adding a few
> days (like the first example).  I didn't go into detail to find the point
> at which it does happen.

you're not hitting an issue with clocks going forward/back for
summertime/daylight savings time?

- Richard Huxton


pgsql-sql by date:

Previous
From: Cedar Cox
Date:
Subject: Re: Calculating the age of a person
Next
From: Cedar Cox
Date:
Subject: Re: timestamp bug