TwistYaWig
asked on
CONNECT BY LEVEL <= MONTHS_BETWEEN stops at 10/31/08?
The following code only creates months through 10/31/08, any clue why it tops and how to fix it?
SELECT LAST_DAY (ADD_MONTHS (TRUNC (date '2008-01-01', 'MM'), 1 * LEVEL - 1)
) MONTH
FROM DUAL
CONNECT BY LEVEL <= MONTHS_BETWEEN (date '2008-12-01', date '2008-01-01') + 1;ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.