Mendola Gaetano wrote: > Hi all, > I noticed that some date are not anymore accepted: > > > Postgres 7.3.3: > > test=# select '18/03/71'::date; > date > ------------ > 1971-03-18 > (1 row) > > > Postgres 7.4beta1: > > test=# select '18/03/71'::date; > ERROR: invalid input syntax for date: "18/03/71" > > > is this the indendeed behaviour ?
Yes, we now honor datestyle to determine how to deal with dates where the year is at the end. You can set your date style to 'euopean' or the new 'DMY' value to allow this. This highlights the fact I need to get the compatibility section written for the history file soon. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
