Horton

Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Ron Mayer <ron@intervideo.com>

View thread
From: "Ron Mayer" <ron@intervideo.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>, "Peter Eisentraut" <peter_e@gmx.net>
Cc: <andrew@dunslane.net>, <pgsql-patches@postgresql.org>
Date: 2003-09-08T23:46:13Z
Lists: pgsql-hackers 
Tom wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Tom Lane writes:
> >> Yes, but by the same token "iso8601" isn't specific enough either.

ISO 8601 gives more specific names.

  ISO 8601 Basic Format:         P2Y10M15DT10H20M30S
  ISO 8601 Alternative Format:   P00021015T102030
  ISO 8601 Extended Format:      P0002-10-15T10:20:30

In a way, the Extended Format is kinda nice, since it’s
almost human readable.

I could put in both the basic and extended ones, and
call the dateformats “iso8601basic” and “iso8601extended”.
The negative is that to do “iso8601basic” right, I’d also
have to tweak the “date” and “time” parts of the code too.