Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

pgsql-advocacy by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group