Re: Problem with data format

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.