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" <tgl@sss.pgh.pa.us> ha scritto nel messaggio
> news:14254.1078551909@sss.pgh.pa.us...
> > "Dario Ottaviano" <dario_ottaviano@togliquestovirgilio.it> 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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>