Horton

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

Peter Eisentraut <peter_e@gmx.net>

View thread View on postgr.es
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, Bruce Momjian <pgman@candle.pha.pa.us>, 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-23T19:16:48Z
Lists: pgsql-general 
Tom Lane writes:

> Other than me, I think you mean.  dd/mm/yyyy and mm/dd/yyyy are
> inherently ambiguous in the real world, and when you can clearly
> determine what the intended meaning is, I think it's more reasonable
> to assume the datestyle isn't set correctly than to reject the data.

That might even make the slightest sense if the supposedly wrong datestyle
would then stay switched.  But the automatic switching only happens for a
certain subsets of inputs and only in that instance.  So if a user did
really mean the opposite setting he will not be happy, and if the user did
not mean the opposite setting he will not be happy either.  So no one is
happy.

-- 
Peter Eisentraut   peter_e@gmx.net