Horton

Re: A creepy story about dates. How to prevent it?

Ron Mayer <ron@intervideo.com>

View thread View on postgr.es
From: "Ron Mayer" <ron@intervideo.com>
To: "scott.marlowe" <scott.marlowe@ihs.com>, "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: "Peter Eisentraut" <peter_e@gmx.net>, "Tom Lane" <tgl@sss.pgh.pa.us>, "Jean-Luc Lachance" <jllachan@nsd.ca>, "Frank Miles" <fpm@u.washington.edu>, "Bruno Wolff III" <bruno@wolff.to>, "Ron Johnson" <ron.l.johnson@cox.net>, <pgsql-general@postgresql.org>
Date: 2003-06-23T22:25:14Z
Lists: pgsql-general 
Scott wrote:
> What are ISO dates?  Are those the ones like 22 Feb 2003?  Just wondering.

Nope, they're the things like 1999-01-08.
The harder to read '930214T131030' is also a valid ISO_8601 format.
http://www.mcs.vuw.ac.nz/technical/software/SGML/doc/iso8601/ISO8601.html


ISO 8601 specifies periods of time too.
For example, ISO-8601's 'P18Y9M' = 18 years, 9 months.

Would people be interested if I submitted a patch that
converted ISO 8601 "periods of time" to postgresql "intervals"?

   Ron