On Mon, Dec 29, 2003 at 05:47:56AM -0800, Theodore Petrosky wrote:
> I don't see the problem... you are specifying the 66th
> day of the 55th month in the year 5555. just a cursory
> glance says that 48 months is 4 years... that gives
> the year as 5559. try your example with real numbers
> (unless these are real)
(Assuming a typo, the select() showed the 665th day).
But there is no 55th month and no 66th day of that month,
the conversion should simply fail and abort the transaction
with an error, shouldn't it ?
Michael van Elst
"A potential Snark may lurk in every tree."
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2003-12-29 16:04:06|
|Subject: Re: date validation problem |
|Previous:||From: Theodore Petrosky||Date: 2003-12-29 13:47:56|
|Subject: Re: date validation problem|