"Tom Lane" <[EMAIL PROTECTED]> wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > I noticed that some date are not anymore accepted: > > test=# select '18/03/71'::date; > > ERROR: invalid input syntax for date: "18/03/71" > > is this the indendeed behaviour ? > > If it does not match your DateStyle setting, then yes. > > regression=# select '18/03/71'::date; > ERROR: invalid input syntax for date: "18/03/71" > regression=# show DateStyle ; > DateStyle > ----------- > ISO, MDY > (1 row) > > regression=# set datestyle = dmy; > SET > regression=# select '18/03/71'::date; > date > ------------ > 1971-03-18 > (1 row)
Great. How I already suggest to Bruce I think is better give an hint on the error reported just to avoid to be overloaded of emails like mine. My cent. Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
