Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-patches by date:

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