Re: Problem with data format - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Problem with data format
Date
Msg-id Pine.LNX.4.33.0403081236530.2365-100000@css120.ihs.com
Whole thread Raw
In response to Problem with data format  ("Dario Ottaviano" <dario_ottaviano@togliquestovirgilio.it>)
List pgsql-admin
On Sat, 6 Mar 2004, Dario Ottaviano wrote:

> Hi, i use Postgresql 7.2 on a windows server (Win 2000 Server).
> The problem is that when i write a date into a timestamp field of a table,
> it writes it in to No-Europe format.

7.2 had some issues with accepting the wrong date formats and just
mangling them until they fit, whether it made sense or not (i.e. you could
insert a date of the format 2003-22-03, which should be illegal, and it
would swap it around and insert 2003-03-22)  The fixes are in 7.3 and
later, I'd suggest upgrading to 7.4.x if you want proper bounds checking
on dates.

> So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes the
> date 03/04/2004 (3 Apr 2004) into the table .

while 7.2 allows you to set a european or US date style, it will gladly
swap months and days to get a date it can insert.  Better, in my opinion,
to use 7.3/7.4 which enforce the date style you set.


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Article on DB encryption
Next
From: "scott.marlowe"
Date:
Subject: Re: Upgrading