> 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
In response to
pgsql-bugs by date
|Next:||From: The Hermit Hacker||Date: 2001-04-27 18:22:12|
|Subject: v7.1.1 branched and released on Tuesday ...|
|Previous:||From: Peter T Mount||Date: 2001-04-27 13:53:15|
|Subject: Re: JDBC Driver Class: Connection Method: isClosed() error|