Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds

Поиск
Список
Период
Сортировка
От Daniele Varrazzo
Тема Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds
Дата
Msg-id CA+mi_8ZdvDV8q03LYtEGdLYrMhvOyfvH6DeD33abH5f2tOP5eQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds  (Ryan Kelly <rpkelly22@gmail.com>)
Список pgsql-bugs
On Mon, Jan 7, 2013 at 5:47 PM, Ryan Kelly <rpkelly22@gmail.com> wrote:

> Alright, now I'm thoroughly confused. What magic makes this true:

"""
Internally interval values are stored as months, days, and seconds.
This is done because the number of days in a month varies, and a day
can have 23 or 25 hours if a daylight savings time adjustment is
involved.
"""

http://www.postgresql.org/docs/9.1/static/datatype-datetime.html

-- Daniele

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

Предыдущее
От: Ryan Kelly
Дата:
Сообщение: Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds
Следующее
От: Tam Tran
Дата:
Сообщение: Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds