Re: A creepy story about dates. How to prevent it? - Mailing list 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@edison.ioppublishing.com
"you have been evaluated.  you have a negative reference count.
 prepare to be garbage collected.  persistence is futile."
        -- Erik Naggum