ADD_MONTHS BUG?

From: Nicolas Bronke <Nicolas.Bronke_at_t-online.de>
Date: 1997/11/24
Message-ID: <65bvba$b46$1@news01.btx.dtag.de>#1/1

Normally I I thought oracle returns the 30.12.98 using the following statement,
select to_Char(add_months(TO_DATE('301198','DDMMYY'),1) ,'DD.MM.YY DAY') from dual

BUT oracle returns 31.12.98. That happens with every Last day of a month with less than 31 days. Incredible is that function in February. Than you receive the 31. March and not the 28 or 29 of march.

If someone use this function for financial calculation he would get unexpected results.

Is that a known bug?
Kind regards
Nicolas Received on Mon Nov 24 1997 - 00:00:00 CST