Re: Date not being parsed as expected

On Fri, Sep 06, 2002 at 05:33:58PM +0900, Jean-Christian Imbeault wrote:
> Martijn van Oosterhout wrote:
> >
> > Wow. Talk about an ambiguous date!
>
> I know. But I thought that I could force the DB to interpret the date as
> Y-M-D, making it unambiguous.
>
> > I don't think ISO dates are allowed to abbreviate any portion, especially
> > the year, since that is what makes the date style clear and unambiguous.
> > Other than the ISO datestyle, is it set to European or US?
>
> Uh? I thought DateStyle could only be ISO, US, or European? Are you
> asking me to set it to ISO AND European?

Well, it used to accept it in older versions of postgresql. I think it's
'SET DATE_STYLE ISO,European' or some such. At one stage there was a
"US-ISO" format which was yyyy-dd-mm. Ugh! That's fixed now IIRC.

Try it, who knows.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.