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

Re: 7.1 euro-style dates insert error

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Chris Storah <cstorah(at)e-mis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.1 euro-style dates insert error
Date: 2001-04-27 16:04:34
Message-ID: 3AE99892.898BB6C@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-bugs
> 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

In response to

Responses

pgsql-bugs by date

Next:From: The Hermit HackerDate: 2001-04-27 18:22:12
Subject: v7.1.1 branched and released on Tuesday ...
Previous:From: Peter T MountDate: 2001-04-27 13:53:15
Subject: Re: JDBC Driver Class: Connection Method: isClosed() error

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