Re: BUG #1630: Wrong conversion in to_date() function. See example.

From: Juan Miguel Paredes <juan(dot)paredes(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Ariel E(dot) Carn /Elizabeth Sosa" <acarna(at)tarifar(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1630: Wrong conversion in to_date() function. See example.
Date: 2005-04-27 14:50:23
Message-ID: 9e0a28690504270750f197285@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Even javascript handles those dates the same way...

On 4/27/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Ariel E. Carná/Elizabeth Sosa" <acarna(at)tarifar(dot)com> writes:
> > PROD=# select to_date('2005-02-32', 'YYYY-MM-DD');
> > to_date
> > ------------
> > 2005-03-04
> > (1 row)
>
> I'm not convinced that's a bug --- most implementations of the Unix
> mktime function will handle out-of-range day numbers like that.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-04-27 14:53:52 Re: BUG #1630: Wrong conversion in to_date() function. See example.
Previous Message Tom Lane 2005-04-27 14:45:42 Re: BUG #1630: Wrong conversion in to_date() function. See example.