oracle、sql server调用自定义函数的方法

1. oracle定义decideDate函数:

CREATE OR REPLACE function decideDate(originalDate in date,timeOffset in integer) return varchar2
as

begin
 return to_char(originalDate +timeOffset/(24*60)  ,'yyyy-mm-dd');
END;

2. oracle调用自定义的decideDate函数:

SELECT DECIDEDATE(to_date('2022-09-09','yyyy-mm-dd'),1440) FROM DUAL;

3. sql server定义decideDate函数:

create function decideDate(@originalDate datetime,@timeOffset int)
returns varchar(20) --返回值类型
as
begin
declare @result varchar(20)
select @result = convert(varchar(10),DATEADD(mi,@timeOffset,@originalDate),120) 
return @result
end

4. sql server调用decideDate函数:

SELECT dbo.decideDate('2022-09-09', 1440)