below is the Query which I am using.

<cfquery name="insert">
    Declare @time SmallDateTime;
    set @time =DATEDIFF(ww,'#Form.StartDate#' , '#Form.EndDate#');
    insert into timehistory()
    values(1,@time)
    </cfquery>

I need to use the @time variable value outside the cfquery. I need to display the value of the declared variable in cfcatch if any error occurs