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

Juan Miguel Paredes <juan.paredes@gmail.com>

From: Juan Miguel Paredes <juan.paredes@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: "Ariel E. Carn /Elizabeth Sosa" <acarna@tarifar.com>, pgsql-bugs@postgresql.org

Date: 2005-04-27T14:50:23Z

Lists: pgsql-bugs

Even javascript handles those dates the same way...

 On 4/27/05, Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> 
> "Ariel E. CarnÃ¡/Elizabeth Sosa" <acarna@tarifar.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
>