Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1630: Wrong conversion in to_date() function. See example. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1630: Wrong conversion in to_date() function. See example.
Date
Msg-id 22161.1114613142@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1630: Wrong conversion in to_date() function. See example.  ("Ariel E. Carná/Elizabeth Sosa" <acarna@tarifar.com>)
Responses Re: BUG #1630: Wrong conversion in to_date() function. See example.
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #1630: Wrong conversion in to_date() function. See example.
Next
From: Juan Miguel Paredes
Date:
Subject: Re: BUG #1630: Wrong conversion in to_date() function. See example.