Re: Date input changed in 7.4 ?
От | Mendola Gaetano |
---|---|
Тема | Re: Date input changed in 7.4 ? |
Дата | |
Msg-id | 001001c36bea$dd9ab9d0$152aa8c0@GMENDOLA2 обсуждение исходный текст |
Ответ на | Date input changed in 7.4 ? ("Mendola Gaetano" <mendola@bigfoot.com>) |
Список | pgsql-hackers |
"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
В списке pgsql-hackers по дате отправления: