Re: Yet Another Timestamp Question: Time Defaults

Поиск
Список
Период
Сортировка
От Nathan Clayton
Тема Re: Yet Another Timestamp Question: Time Defaults
Дата
Msg-id 486641188.20130121231120@gmail.com
обсуждение исходный текст
Ответ на Re: Yet Another Timestamp Question: Time Defaults  (Gavan Schneider <pg-gts@snkmail.com>)
Ответы Re: Yet Another Timestamp Question: Time Defaults  (Gavan Schneider <pg-gts@snkmail.com>)
Список pgsql-general
Monday, January 21, 2013, 8:56:38 PM, you wrote:

>>Except for days that are 23-hours long, or 25, or other (it's a big
>>world with all sorts of timezone rules).
>>
> The day's length may change but I don't believe there is
> anywhere that allows for the local time of day to equal or be
> greater than 24:00:00 without rolling over to the next day.

I only wish. I work with a transactional system from the 70s on
a daily basis that decided to store something like a "work date" and
"work time". The date changes whenever they decide to dateroll the
system. Until then the time field continues to grow, so you see times
like 25:00 and 26:00 all the time.

Exceptions abound.

--
 Nathan



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Running update in chunks?
Следующее
От: Johann Spies
Дата:
Сообщение: Re: Question on Trigram GIST indexes