Re: timestamp bug

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: timestamp bug
Дата
Msg-id 3B07B8C2.CD8A43EA@archonet.com
обсуждение исходный текст
Ответ на timestamp bug  (Cedar Cox <cedarc@visionforisrael.com>)
Ответы Re: timestamp bug  (Cedar Cox <cedarc@visionforisrael.com>)
Список 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 по дате отправления:

Предыдущее
От: Cedar Cox
Дата:
Сообщение: Re: Calculating the age of a person
Следующее
От: Cedar Cox
Дата:
Сообщение: Re: timestamp bug