Re: Wrong date inserts - Mailing list pgsql-admin

From Tom Lane
Subject Re: Wrong date inserts
Date
Msg-id 22185.1018803998@sss.pgh.pa.us
Whole thread Raw
In response to Wrong date inserts  (Egon Reetz <reetz@usco.de>)
Responses Re: Wrong date inserts  (Egon Reetz <reetz@usco.de>)
List pgsql-admin
Egon Reetz <reetz@usco.de> writes:
> It looks like day and month are exchanged, when the day is less or equal
> 12.

Sounds like you should change DateStyle to tell the truth about the date
format you are using.  The system has to rely on that when the field
values don't make it obvious which component is which.

Looks like you want 'German' datestyle for this input.

            regards, tom lane

pgsql-admin by date:

Previous
From: Egon Reetz
Date:
Subject: Wrong date inserts
Next
From: Egon Reetz
Date:
Subject: Re: Wrong date inserts