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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ron Mayer" <ron(at)intervideo(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Date: 2003-09-08 05:47:17
Message-ID: 4738.1063000037@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches

"Ron Mayer" <ron(at)intervideo(dot)com> writes:
> Compared to the ISO 8601 time interval specification, the
> postgresql interval syntax is quite verbose. For example:

> Postgresql interval: ISO8601 Interval
> ---------------------------------------------------
> '1 year 6 months' 'P1Y6M'
> '3 hours 25 minutes 42 seconds' 'PT3H25M42S'

Er, don't we support that already? I know I saw code to support
something much like that syntax last time I looked into the datetime
routines.

regards, tom lane

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message andrew 2003-09-08 06:32:17 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Ron Mayer 2003-09-08 04:50:49 ISO 8601 "Time Intervals" of the "format with time-unit deignators"

Browse pgsql-general by date

  From Date Subject
Next Message andrew 2003-09-08 06:32:17 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Sergey Suleymanov 2003-09-08 05:40:37 Re: default EXECUTE privilege

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeroen Ruigrok/asmodai 2003-09-08 05:52:39 Re: FreeBSD/i386 thread test
Previous Message Ron Mayer 2003-09-08 04:50:49 ISO 8601 "Time Intervals" of the "format with time-unit deignators"

Browse pgsql-patches by date

  From Date Subject
Next Message andrew 2003-09-08 06:32:17 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Tom Lane 2003-09-08 05:14:26 Re: Minor lmgr code cleanup