Postgres Pro
Downloads
Home   >   mailing lists

Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Ron Mayer
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id POEDIPIPKGJJLDNIEMBEEEAGDBAA.ron@intervideo.com
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [pgsql-advocacy] interesting PHP/MySQL thread
Next
From: Chris Smith
Date:
Subject: Re: [pgsql-advocacy] interesting PHP/MySQL thread