Postgres Pro
Downloads
Home   >   mailing lists

Re: Date not being parsed as expected - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: Date not being parsed as expected
Date
Msg-id 3D786876.8070709@mega-bucks.co.jp
Whole thread Raw
In response to Date not being parsed as expected  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Responses Re: Date not being parsed as expected  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Date not being parsed as expected  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Tree view 
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?

Jc

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Date not being parsed as expected
Next
From: rolf.ostvik@axxessit.no
Date:
Subject: Re: Date not being parsed as expected