Horton

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

scott.marlowe <scott.marlowe@ihs.com>

View thread View on postgr.es
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jean-Luc Lachance <jllachan@nsd.ca>, 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:35:35Z
Lists: pgsql-general 
On Thu, 19 Jun 2003, Tom Lane wrote:

> 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.

Which are?  Honestly, I see no good use for the lax parsing.