我现在正在把Sqlserver的存储过程改为Oracle的存储过程,遇到了dateadd函数,不知道怎么样才能在Oracle中实现该函数的功能?我刚刚接触Oracle的存储过程,很多都不是很熟悉,希望高手能指导指导。Oracle中以下语句如何实现:
INSERT INTO TempWorkInfo(WorkID,ID,OperID,WriteTime,Req_sub_Time) Values(workid,ID,operid,getdate(),dateadd(s,worktime+time,getdate()));
INSERT INTO TempWorkInfo(WorkID,ID,OperID,WriteTime,Req_sub_Time) Values(workid,ID,operid,getdate(),dateadd(s,worktime+time,getdate()));
Values(workid,ID,operid,sysdate,(worktime+time)/60/60/24+sysdate);
Values(workid,ID,operid,sysdate,(worktime+time)/60/60/24+sysdate);