Re: timestamp bug
Richard Huxton <dev@archonet.com>
From: Richard Huxton <dev@archonet.com>
To: Cedar Cox <cedarc@visionforisrael.com>
Cc: pgsql-sql@postgresql.org
Date: 2001-05-20T12:29:54Z
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