Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group