Re: timestamp with time zone a la sql99

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: timestamp with time zone a la sql99
Дата
Msg-id Pine.LNX.4.44.0410252114250.2015-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: timestamp with time zone a la sql99  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: timestamp with time zone a la sql99  (Bruno Wolff III <bruno@wolff.to>)
Re: timestamp with time zone a la sql99  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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?

Well, this is the last mail I send before I've been thinking about this 
for a while more :-)

-- 
/Dennis Björklund



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

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