Re: '1 year' = '360 days' ????

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: '1 year' = '360 days' ????
Дата
Msg-id E14F89B2-258D-11D9-B9F1-000A95C88220@myrealbox.com
обсуждение исходный текст
Ответ на Re: '1 year' = '360 days' ????  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Ответы Re: '1 year' = '360 days' ????  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Oct 24, 2004, at 4:13 PM, Pierre-Frédéric Caillaud wrote:

>     How can we sort intervals meaningfully in these conditions ? Can we ?
> In fact the value of an interval depends on the application, and
> intervals with months are in another 'world' than intervals with only
> seconds... same thing for years.

Added to this, I've been wondering whether '1 day'::interval is also
problematic wrt daylight savings time or changing time zones. The whole
thing seems pretty hairy to me.

Michael Glaesemann
grzm myrealbox com


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
Следующее
От: Marek Lewczuk
Дата:
Сообщение: sequence behavior - is this correct