Re: timestamp with time zone a la sql99

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: timestamp with time zone a la sql99
Дата
Msg-id 20041025194057.GA26356@wolff.to
обсуждение исходный текст
Ответ на Re: timestamp with time zone a la sql99  (Dennis Bjorklund <db@zigo.dhs.org>)
Список pgsql-hackers
On Mon, Oct 25, 2004 at 21:18:52 +0200, Dennis Bjorklund <db@zigo.dhs.org> wrote:
> On Mon, 25 Oct 2004, Josh Berkus wrote:
> 
> > Hour/Minute/Second/ms
> > Day/Week
> > Month/Year
> 
> This is embarrasing. I'm still a bit confused :-)
> 
> The standard treat days as a separate entry, it does not assume that a day 
> is 24 hours. It restricts the hour field to the interval 0-23 so one can 
> never have something like 25 hours. So it does not need to worry about how 
> many days that translate to.
> 
> And why do we need weeks also?

For convenience. Just like years are a group of months, weeks are a group
of days.


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

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: timestamp with time zone a la sql99
Следующее
От: Tom Lane
Дата:
Сообщение: Re: timestamp with time zone a la sql99