Re: Wrong date inserts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Egon Reetz <reetz(at)usco(dot)de>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Wrong date inserts
Date: 2002-04-14 17:06:38
Message-ID: 22185.1018803998@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Egon Reetz <reetz(at)usco(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Egon Reetz 2002-04-14 18:04:29 Re: Wrong date inserts
Previous Message Egon Reetz 2002-04-14 11:26:05 Wrong date inserts