Re: Question about Postgresql time fields(possible bug) - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Question about Postgresql time fields(possible bug)
Date
Msg-id 200601101314.32227.josh@agliodbs.com
Whole thread Raw
In response to Re: Question about Postgresql time fields(possible bug)  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-hackers
Tony, Dave,

> That's not really the point. The ISO 8601 standard allows midnight to be
> expressed as 00:00:00 or 24:00:00 to enable you to tell which midnight
> is being referred to (ie. The beginning or the end of the day).

IIRC, the reason for supporting 24:00:00 is that some popular client 
languages (including PHP, I think) use this number to express "midnight".    
I personally also find it a useful way to distinguish between "blank 
time" (00:00) an "specifically intentionally midnight" (24:00).

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Question about Postgresql time fields(possible bug)
Next
From: Tom Lane
Date:
Subject: Re: Question about Postgresql time fields(possible bug)