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

I think he was thiniing about making the **IN** and out of the date functions to be ANSI only.

Bruno Wolff III wrote:

> 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)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>