"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> "Mendola Gaetano" <mendola@bigfoot.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
