| From: | Chris Storah <cstorah(at)emis-support(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | 7.1 euro-style dates insert error |
| Date: | 2001-04-27 07:58:43 |
| Message-ID: | 004e01c0ceef$e4d3b840$c60215ac@wkcws2k1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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;
gives:
a
--------
1997-10-23
1997-10-13
1997-2-10
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?
Thanks,
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2001-04-27 09:49:29 | Optimalisation options change query results |
| Previous Message | Robert E. Bruccoleri | 2001-04-27 01:38:08 | Re: FWD: broken SGI tarfiles |