本人提供一变通解决方法,以getdate为例,通过视图来解决这个问题:
---------------------------------------------------------------
create view v_getdate
as
select * from (select cast(getdate() as datetime) as output) as a
go
---------------------------------------------------------------
create function f_getdate()
returns datetime
as
begin
declare @n datetime
select @n = output from v_getdate
return(@n)
end
go
---------------------------------------------------------------