Postgres Pro
Downloads
Home   >   mailing lists

Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' - Mailing list pgsql-patches

From Ron Mayer
Subject Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date
Msg-id POEDIPIPKGJJLDNIEMBEIEBFDJAA.ron@intervideo.com
Whole thread Raw
In response to Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ISO 8601 'Time Intervals' of the 'format with time-unit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: ISO 8601 'Time Intervals' of the 'format with time-unit  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Tree view 
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.

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Next
From: Tom Lane
Date:
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"