IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'au_info' AND type = 'P')
DROP PROCEDURE au_info
GO
GO
CREATE PROCEDURE au_info
@startdate datetime,
@enddate datetime,
@rettime varchar(8000) output
AS
set @rettime =DATEDIFF ( second ,@startdate, @enddate)
select @rettime
GO
DECLARE @rettime varchar(8000)
EXECUTE au_info @startdate = '2007-07-6 19:00:00', @enddate = '2007-07-6 19:45:11',@rettime= ''
declare datediff procedure for au_info
@startdate = :ls_begin,
@enddate = :ls_end,
@rettime = '' output using sqlca;
execute datediff;
fetch datediff into:ls_diff;
close datediff;