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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: 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:22:44
Message-ID: 9360.1056039764@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-19 16:25:16 Re: A creepy story about dates. How to prevent it?
Previous Message Jimmie H. Apsey 2003-06-19 16:10:46 Re: A View to Share