Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.1 euro-style dates insert error - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: 7.1 euro-style dates insert error
Date
Msg-id 3AE99892.898BB6C@alumni.caltech.edu
Whole thread Raw
In response to 7.1 euro-style dates insert error  (Chris Storah <cstorah@e-mis.com>)
List pgsql-bugs
Tree view 
> Automatically thinks that the last value is a US style date.
> Date style is set to EURO, but I assume this has no affect on the date
> parsing at insert time.

Yes it does, for ambiguous cases such as yours.

> If the dates are entered as 'ccyy.mm.dd' it is okay - unfortunately all my
> dates are in the format 'dd.mm.ccyy'.
> Is this a bug or a user error?

I'm willing to bet that the date style is *not* set to "European".
Please demonstrate with a "show datestyle" and "select date
'2.10.1997'"...

                     - Thomas

pgsql-bugs by date:

Previous
From: Peter T Mount
Date:
Subject: Re: JDBC Driver Class: Connection Method: isClosed() error
Next
From: Victor Wagner
Date:
Subject: Invalid outer joins with subquery