Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Ron Mayer" <ron@intervideo.com>
Cc: pgsql-patches@postgresql.org
Date: 2003-09-08T05:47:17Z
Lists: pgsql-hackers
"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