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

On Thu, Jun 19, 2003 at 02:43:12 -0500,
  Ron Johnson <ron.l.johnson@cox.net> wrote:
>
> OTOH, Andrew Snow's method (alway use ANSI standard YYYY-MM-DD)
> is guaranteed to work.  Have your app convert to that format before
> inserting, and then PostgreSQL is guaranteed to puke if there's
> a problem.

No it isn't. In 7.4:
area=> select '2003-20-02'::date;
    date
------------
 2003-02-20
(1 row)