最小源代码擂台

sdxiong

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


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

sdxiong

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

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

nyfor

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

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

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

DragonBill

晕~~~~

hotiice

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

hotiice

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

hotiice

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 编辑 ]

nyfor

原帖由 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 的函数返回的结果不一致.

DragonBill

快到24了

我很关心  sdxiong 的那一个Byte是怎么出来的

nyfor

原帖由 DragonBill 于 2008-5-22 18:27 发表
快到24了

我很关心  sdxiong 的那一个Byte是怎么出来的

我再研究研究, 看看这一个字节能不能也弄出来
估计弄不出来的...