Re: Yet Another Timestamp Question: Time Defaults

From: Nathan Clayton <nathanclayton(at)gmail(dot)com>
To: Gavan Schneider <pg-gts(at)snkmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Yet Another Timestamp Question: Time Defaults
Date: 2013-01-22 07:11:20
Message-ID: 486641188.20130121231120@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-01-22 08:44:47 Re: proposal: fix corner use case of variadic fuctions usage
Previous Message Jeff Janes 2013-01-22 07:07:02 Re: Running update in chunks?