Re: timestamp bug

From: Richard Huxton <dev(at)archonet(dot)com>
To: Cedar Cox <cedarc(at)visionforisrael(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: timestamp bug
Date: 2001-05-20 12:29:54
Message-ID: 3B07B8C2.CD8A43EA@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Cedar Cox 2001-05-20 13:42:59 Re: timestamp bug
Previous Message Cedar Cox 2001-05-20 10:07:25 Re: Calculating the age of a person