Wrong date inserts - Mailing list pgsql-admin

From Egon Reetz
Subject Wrong date inserts
Date
Msg-id 3CB9674D.5E1BB361@usco.de
Whole thread Raw
Responses Re: Wrong date inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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








pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: A *short* planner question
Next
From: Tom Lane
Date:
Subject: Re: Wrong date inserts