What version of Postgresql are you running. Versions 7.2 and before would
gladly swap around day / month when they needed to be to fit, and this
caused me a few headaches where I had data feeds that were partially
failing and couldn't figure out why.
On Sat, 6 Mar 2004, Dario Ottaviano wrote:
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
"Tom Lane" <[EMAIL PROTECTED]> ha scritto nel messaggio
news:[EMAIL PROTECTED]
> "Dario Ottaviano" <[EMAIL PROTECTED]> writes:
> > So, for
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
mang
"Dario Ottaviano" <[EMAIL PROTECTED]> writes:
> 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
-
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 .
