"Mendola Gaetano" <mendola(at)bigfoot(dot)com> 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)
regards, tom lane