| From: | "Ron Mayer" <ron(at)intervideo(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jean-Luc Lachance" <jllachan(at)nsd(dot)ca>, "Frank Miles" <fpm(at)u(dot)washington(dot)edu>, "Bruno Wolff III" <bruno(at)wolff(dot)to>, "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: A creepy story about dates. How to prevent it? |
| Date: | 2003-06-23 22:25:14 |
| Message-ID: | POEDIPIPKGJJLDNIEMBEEEAGDBAA.ron@intervideo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-06-23 22:30:09 | Re: [GENERAL] interesting PHP/MySQL thread |
| Previous Message | Bruce Momjian | 2003-06-23 22:21:07 | Re: [HACKERS] PlPython |