7.0.x okay, 7.1 incorrect (CVS from 24th April):
create table test(aaa date);
insert into test(aaa) values ('23.10.1997');
insert into test(aaa) values ('13.10.1997');
insert into test(aaa) values ('2.10.1997');
select * from test;
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.
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?
pgsql-bugs by date
|Next:||From: Peter Eisentraut||Date: 2001-04-26 14:49:10|
|Subject: Re: Startup Problems on Win2K|
|Previous:||From: Oscar FRANCOIS||Date: 2001-04-26 13:02:27|
|Subject: JDBC Driver Class: Connection Method: isClosed() error|