drop procedure between_time;
create procedure between_time
(stime DATETIME HOUR TO second,etime DATETIME HOUR TO second)
returning interval second to second;
define ret interval second to second;
let ret = stime - etime;
return ret;
end procedure;
execute procedure between_time('20:00:10','19:59:00');
|