Problem with data format

[Dario Ottaviano]

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.

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 .

Why?
Is there a way to avoid this?

Tanck you for help!
Dario

[Tom Lane]

Post by Dario Ottaviano
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 .

You need to change the DateStyle setting to agree with your desired
format.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Dario Ottaviano]

That's ok, but how can i do that?
I tried something like "Set datestyle='European', but nothing changed!

Please, can you help me!
Thank you,
Dario Ottaviano

Post by Tom Lane

Post by Dario Ottaviano
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 .

You need to change the DateStyle setting to agree with your desired
format.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org