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

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

"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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Juan Miguel Paredes 2005-04-27 14:50:23 Re: BUG #1630: Wrong conversion in to_date() function. See example.
Previous Message Don Courtney 2005-04-27 14:41:33 BUG #1634: Configure step for build does not define HAVE_POSIX_SIGNALS