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)