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

Re: Wrong date inserts

From: Egon Reetz <reetz(at)usco(dot)de>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Wrong date inserts
Date: 2002-04-14 18:04:29
Message-ID: 1069B596-4FD2-11D6-A7B8-0003936D343A@usco.de (view raw or flat)
Thread:
Lists: pgsql-admin
Well, will look forward to find something about DateStyle, but
shouldn't both dates handled equally.
Same input format should result into the same result, shouldn't it?

Regards

Egon

Am Sonntag den, 14. April 2002, um 19:06, schrieb Tom Lane:

> 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

pgsql-admin by date

Next:From: Serguei MokhovDate: 2002-04-14 21:38:23
Subject: Re: Wrong date inserts
Previous:From: Tom LaneDate: 2002-04-14 17:06:38
Subject: Re: Wrong date inserts

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