Wrong date inserts

From: Egon Reetz <reetz(at)usco(dot)de>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Wrong date inserts
Date: 2002-04-14 11:26:05
Message-ID: 3CB9674D.5E1BB361@usco.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

database is 7.1.3, compiled with -enable-local -enable-recode
-enable-multibyte=UNICODE,
initdb -E UNICODE, createdb -E LATIN1.

I have a table with 2 date fields (start_date, end_date).

When I do: insert into my_table values ('12.04.2002', '31.08.2002');
I'm getting with select * from my_table:
2002-12-04 | 2002-08-31

It looks like day and month are exchanged, when the day is less or equal
12. Is this a known behavior? Anyone has an experiance like this with
7.2.1?

Thanks

Egon

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-04-14 17:06:38 Re: Wrong date inserts
Previous Message Dave Menendez 2002-04-13 23:17:59 Query planner quirk?