| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Peter Haworth <pmh(at)edison(dot)ioppublishing(dot)com> |
| Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 15:07:53 |
| Message-ID: | 3EF1D1C9.5040406@cvc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
WHOA!
Peter Haworth wrote:
> 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?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-06-19 15:12:54 | Re: A creepy story about dates. How to prevent it? |
| Previous Message | Dennis Gearon | 2003-06-19 15:04:56 | Re: A creepy story about dates. How to prevent it? |