Re: Problem with data format

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(at)sss(dot)pgh(dot)pa(dot)us> ha scritto nel messaggio
> news:14254(dot)1078551909(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> > "Dario Ottaviano" <dario_ottaviano(at)togliquestovirgilio(dot)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
>