create or replace function f$getTime(
time1 nvarchar2
)
return nvarchar2
as
var_value nvarchar2(255);
begin
select trunc(15960/3600/24) || '天' || to_char(to_date(mod(15960,3600*24),'sssssss'),'fmhh24":"mi":"ss""')
into var_value from dual
return var_value;
end;
哪里错了 在线求助！
------解决方案--------------------
- SQL code
\create or replace function fgetTime(time1 in nvarchar2)return nvarchar2asvar_value nvarchar2(255);begin select trunc(15960/3600/24) || '天' || to_char(to_date(mod(15960,3600*24),'sssssss'),'fmhh24":"mi":"ss""') into var_value from dual; --缺少分号，可以放在函数里调试一下就能看到报错的信息return var_value;end;