Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: Frank Miles <fpm@u.washington.edu>, Bruno Wolff III <bruno@wolff.to>, Ron Johnson <ron.l.johnson@cox.net>, pgsql-general@postgresql.org
Date: 2003-06-19T16:22:44Z
Lists: pgsql-general 
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> Shouldn't dates be validated using the *LOCALE setting and not try to
> guess?

It would make sense to offer a "strict" mode in which the date order
has to be what DateStyle suggests.  I'm astonished that no one seems
to get the point that there are also good uses for "lax" parsing.

			regards, tom lane