Horton

Re: A creepy story about dates. How to prevent it?

Bruno Wolff III <bruno@wolff.to>

View thread View on postgr.es
From: Bruno Wolff III <bruno@wolff.to>
To: Ron Johnson <ron.l.johnson@cox.net>
Cc: pgsql-general@postgresql.org
Date: 2003-06-19T10:35:37Z
Lists: 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)