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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>, Frank Miles <fpm(at)u(dot)washington(dot)edu>, Bruno Wolff III <bruno(at)wolff(dot)to>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: A creepy story about dates. How to prevent it?
Date: 2003-06-19 16:35:35
Message-ID: Pine.LNX.4.33.0306191034570.7420-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 19 Jun 2003, Tom Lane wrote:

> Jean-Luc Lachance <jllachan(at)nsd(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2003-06-19 16:36:10 SQL question
Previous Message Tom Lane 2003-06-19 16:25:16 Re: A creepy story about dates. How to prevent it?