QUOTE:

---

原帖由 nyfor 于 2008-5-14 08:57 发表

嗯, 无极限,

---

嘿嘿, 再下去真想不去方法了.
感觉到了尽头

都是牛人啊

你们你们你们。。。。又要我伤脑筋了


最后一次，就最后一次修改。。。。。这个函数上实在花了太多的时间

Congratulation ... Code Length: 349 Bytes. Times: 00:00:05

完成任务，不再修改了，下班走人。。。。

QUOTE:

---

原帖由 sdxiong 于 2008-5-14 17:24 发表
Congratulation ... Code Length: 349 Bytes. Times: 00:00:05

完成任务，不再修改了，下班走人。。。。

---

怎么总是能这么快速的前进呀

晕~~~~

declare
*
ERROR at line 1:
ORA-06531: Reference to uninitialized collection
ORA-06512: at line 49

Sorry: stop at p_date_string=20000229,p_months=1
my_add_months returned: 20000329
add_months returned: 20000331

ADD_MONTHSThe ADD_MONTHS function returns the date that is n months after the specified date.

Return Value

DATETIME

Syntax

ADD_MONTHS(start_datetime, n)

Arguments

start_datetime
A DATETIME expression that identifies the starting date. When the day component of start_datetime is the last day of the month or when the returned month has fewer days, then the returned day component is the last day of the month. Otherwise, the day component of the returned date is the same as the day component of start_datetime. See Example 7-2, "End-of-Month Calculation".

n
An INTEGER that identifies the number of months to be added to start_datetime.

Examples

Example 7-2 End-of-Month Calculation

The following statement displays the date of the day that is one month after January 30, 2000.

SHOW ADD_MONTHS('30Jan00', 1)

Since February 29 was the last day of February 2000, ADD_MONTHS returns February 29, 2000.

29-Feb-00
http://download.oracle.com/docs/ ... _functions_1005.htm

[ 本帖最后由 hotiice 于 2008-5-21 16:00 编辑 ]

QUOTE:

---

原帖由 hotiice 于 2008-5-21 15:40 发表
Sorry: stop at p_date_string=20000229,p_months=1
my_add_months returned: 20000329
add_months returned: 20000331

---

Oracle的 add_months 没错, 当起始日期为该月最后一天或者大约新日期月份的最后一天时, 取新日期月份的最后一天作为结果.
是你写的函数返回值不正确, 和 Oracle 的函数返回的结果不一致.