From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: timestamp bug |
Date: | 2001-05-20 13:42:59 |
Message-ID: | Pine.LNX.4.21.0105201608430.19641-100000@nanu.visionforisrael.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Ouch. Ok, that looks like it. I guess I should just set the time part to
13:00 (when DST never changes)? Or, can I set the time zone to GMT (for
this single SQL statement) or something that doesn't have DST? Perhaps a
different data type? Suggestions?
Thanks,
-Cedar
On Sun, 20 May 2001, Richard Huxton wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Subhramanya Shiva | 2001-05-20 17:16:07 | problem while starting server ??? |
Previous Message | Richard Huxton | 2001-05-20 12:29:54 | Re: timestamp bug |