Re: Date input changed in 7.4 ?

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "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)

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