Re: Comment on timezone and interval types

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Comment on timezone and interval types
Дата
Msg-id 20041029174620.GA28827@wolff.to
обсуждение исходный текст
Ответ на Re: Comment on timezone and interval types  (Guy Fraser <guy@incentre.net>)
Ответы Re: Comment on timezone and interval types  (Stuart Bishop <stuart@stuartbishop.net>)
Список pgsql-general
On Fri, Oct 29, 2004 at 11:14:31 -0600,
  Guy Fraser <guy@incentre.net> wrote:
>
> 1 day should always be calculated as 24 hours, just as an hour
> is calculated as 60 minutes...

If you want 24 hours you can use 24 hours. Days are not constant length,
just like months aren't constant length.

> Since interval does not store an actual time range, it is not sensitive to
> daylight savings.

When inetervals are added or subtracted from timestamps there is an actual
time range which makes DST transitions relevant.

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

Предыдущее
От: "J. Michael Crawford"
Дата:
Сообщение: Re: UTF-8 -> ISO8859-1 conversion problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tasks