Re: BUG #1993: Adding/subtracting negative time intervals

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1993: Adding/subtracting negative time intervals
Дата
Msg-id 8993.1130210512@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #1993: Adding/subtracting negative time intervals  (Klint Gore <kg@kgb.une.edu.au>)
Ответы Re: BUG #1993: Adding/subtracting negative time intervals  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-bugs
Klint Gore <kg@kgb.une.edu.au> writes:
> That's changed since v7.4.7

Yup.  '1 week' = '7 days' which is no longer the same as 7*24 hours.
In particular, as of 8.1 local noon plus one day is still local noon,
even if there was a DST change in between.  Adding 24 hours, on the
other hand, might give 11am or 1pm.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Klint Gore
Дата:
Сообщение: Re: BUG #1993: Adding/subtracting negative time intervals
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: BUG #1993: Adding/subtracting negative time intervals