| From: | "Peter Haworth" <pmh(at)edison(dot)ioppublishing(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <cmarin(at)dims(dot)com>, "Pgsql-General-post (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: A creepy story about dates. How to prevent it? |
| Date: | 2003-06-19 13:46:31 |
| Message-ID: | PGM.20030619134631.10313.3419@edison.ioppublishing.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 18 Jun 2003 15:09:44 -0600 (MDT), scott.marlowe wrote:
> Why not accept a date of 04/44/2003 and just wrap it into May?
Unbelievably, to_date() already does that in 7.3.3:
pmh=> select to_date('2003-04-44','yyyy-mm-dd');
to_date
------------
2003-05-14
(1 row)
I raised this issue along with the date component order switching in April.
Someone (possibly Karel Zak) did say that they were going to look into it,
but it doesn't look like anything got done about it in 7.3. Maybe it's
better in 7.4?
--
Peter Haworth pmh(at)edison(dot)ioppublishing(dot)com
"you have been evaluated. you have a negative reference count.
prepare to be garbage collected. persistence is futile."
-- Erik Naggum
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-06-19 13:52:26 | Re: A creepy story about dates. How to prevent it? |
| Previous Message | Jonathan Bartlett | 2003-06-19 13:39:35 | Re: A creepy story about dates. How to prevent it? |