Re: Date input changed in 7.4 ?

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

In response to

Browse pgsql-hackers by date

  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 ?