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

From: "Ron Mayer" <ron(at)intervideo(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: <andrew(at)dunslane(dot)net>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date: 2003-09-08 23:46:13
Message-ID: POEDIPIPKGJJLDNIEMBEIEBFDJAA.ron@intervideo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches


Tom wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)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.

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tom Lane 2003-09-09 04:19:48 Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Previous Message Ron Mayer 2003-09-08 23:05:38 Re: [PATCHES] ISO 8601 "Time Intervals" of the "format with time-unit designators"

Browse pgsql-general by date

  From Date Subject
Next Message Relaxin 2003-09-09 00:35:39 Re: ODBC Issue
Previous Message Joseph Shraibman 2003-09-08 23:34:29 Re: why does count take so long?

Browse pgsql-hackers by date

  From Date Subject
Next Message Jenny - 2003-09-09 01:09:33 Re: row level lock and table level locks
Previous Message Tom Lane 2003-09-08 23:35:23 Re: undefine currval()

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-09-09 04:19:48 Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Previous Message Ron Mayer 2003-09-08 23:05:38 Re: [PATCHES] ISO 8601 "Time Intervals" of the "format with time-unit designators"