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 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 > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match