From: | "Mendola Gaetano" <mendola(at)bigfoot(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Date input changed in 7.4 ? |
Date: | 2003-08-26 15:58:17 |
Message-ID: | 001001c36bea$dd9ab9d0$152aa8c0@GMENDOLA2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"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
From | Date | Subject | |
---|---|---|---|
Next Message | Jenny - | 2003-08-26 16:05:45 | row level locks |
Previous Message | Mendola Gaetano | 2003-08-26 15:53:25 | Re: Date input changed in 7.4 ? |