On Mon, Dec 29, 2003 at 11:04:06AM -0500, Tom Lane wrote:
> Michael van Elst <[EMAIL PROTECTED]> writes:
> > 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 ?
>
> I believe this is an acknowle
Michael van Elst <[EMAIL PROTECTED]> writes:
> 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 ?
I believe this is an acknowledged bug in to_date, which Karel hasn't
yet got around to fixing.
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 . just a cursory
> glance says that 48 months is 4 years... that gives
> the year as 5559. try your example with real numbers
> (unl
I don't see the problem... you are specifying the 66th
day of the 55th month in the year . 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)
select to_date('13122003','ddmm');
to_date
--
sir,
in postgresql 7.3.2 when we are trying to query like
select to_date('66555','ddmm');
the output is
5559-09-06
it is not validating the day and month and unknown format
is the output..
any help regarding this is greatful...
thank you
---(end of b
