56,679
社区成员
发帖
与我相关
我的任务
分享
DROP FUNCTION IF EXISTS fn_isreplace;
delimiter //
Create function fn_isreplace
(`update` datetime,timezone int)
returns int
begin
declare `curtime` datetime;
declare curlttime datetime;
declare curutctime datetime;
declare re_sec int;
set `curtime` = NOW();
set curutctime = CONVERT_TZ(NOW(),'+08:00','+00:00');
if `update` <> 0 then
begin
if timezone >= 1 then
set `curtime` = CONVERT_TZ(NOW(),'+08:00','+00:00');
else
begin
if curutctime - curlttime = 0 then
set `curtime` = curutctime;
else
set `curtime` = curlttime;
end if;
end;
end if;
set re_sec = Round(Cast((`update` - `curtime`) as decimal),0);
end;
else
set re_sec = 0;
end if;
return re_sec;
end//
delimiter ;
mysql> DROP FUNCTION IF EXISTS fn_isreplace;
Query OK, 0 rows affected, 1 warning (0.05 sec)
mysql> delimiter //
mysql> Create function fn_isreplace
-> (`update` datetime,timezone int)
-> returns int
-> begin
-> declare `curtime` datetime;
-> declare curlttime datetime;
-> declare curutctime datetime;
-> declare re_sec int;
-> set `curtime` = NOW();
-> set curutctime = CONVERT_TZ(NOW(),'+08:00','+00:00');
->
-> if `update` <> 0 then
-> begin
-> if timezone >= 1 then
-> set `curtime` = CONVERT_TZ(NOW(),'+08:00','+00:00');
-> else
-> begin
-> if curutctime - curlttime = 0 then
-> set `curtime` = curutctime;
-> else
-> set `curtime` = curlttime;
-> end if;
-> end;
-> end if;
-> set re_sec = Round(Cast((`update` - `curtime`) as decimal),0);
-> end;
-> else
-> set re_sec = 0;
->
-> end if;
-> return re_sec;
-> end//
Query OK, 0 rows affected (0.05 sec)
mysql> delimiter ;
mysql>