mysql怎么写一个带输入输出参数的用户自定义函数 - 编程论坛

#2

purana2007-11-17 17:06

这个函数初步看了一下...
是错误的.

#3

system322007-11-17 17:40

回复：（purana）这个函数初步看了一下...是错误的.

我知道。我改的时候，不小心就把改动的传上来了，
use studentRegisterManager
go
create function differentTime(@section_id varchar(10),@currenttime datetime)
returns int
as
begin
declare @different int
declare @time datetime

set @time = (select section_set_time from [section] where section_id=@section_id)

set @different=DATEDIFF( d, @time,@currenttime)

return @different
end
这个对的了，能给我一个MYSQL的版本吗？？

#4

purana2007-11-17 18:15

delimiter $$
drop function if exists differentTime$$
create function differentTime(in_section_id varchar(10),currenttime datetime)
returns int
begin
declare different int;
declare ttime datetime;
set ttime = (select section_set_time from section where section_id=in_section_id);

set different=to_days(currenttime)-to_days(ttime);

return different;
end $$
delimiter ;

#5

system322007-11-17 18:37

谢谢！非常感谢！