Skip site navigation (1) Skip section navigation (2)

7.1 euro-style dates insert error

From: Chris Storah <cstorah(at)e-mis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 7.1 euro-style dates insert error
Date: 2001-04-26 13:03:50
Message-ID: 034801c0ce51$6171e1a0$c60215ac@wkcws2k1 (view raw or flat)
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


Responses

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-04-26 14:49:10
Subject: Re: Startup Problems on Win2K
Previous:From: Oscar FRANCOISDate: 2001-04-26 13:02:27
Subject: JDBC Driver Class: Connection Method: isClosed() error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group