From: Richard Huxton <dev@archonet.com>
To: Cedar Cox <cedarc@visionforisrael.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: timestamp bug
Date: Sun, 20 May 2001 13:29:54 +0100
Message-ID: <3B07B8C2.CD8A43EA@archonet.com> (raw)
References: <Pine.LNX.4.21.0105201225150.17216-100000@nanu.visionforisrael.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, cedarc@visionforisrael.com
Subject: Re: timestamp bug
In-Reply-To: <3B07B8C2.CD8A43EA@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox