sql - Error converting Sum[Field] as numeric or float -

sql - Error converting Sum[Field] as numeric or float -

i using function total of column field :

alter function [dbo].[gettwoweeklyworktime](@employeeid int,@payperiodid varchar(10)) returns int begin declare @startdate datetime declare @enddate datetime select @startdate=[periodstartdate],@enddate=[periodenddate] payperiod payperiodid=@payperiodid -- declare homecoming variable here declare @resultvar numeric(10,2) select @resultvar= sum([workingtime])/60 [daylog] employeeid =@employeeid , createddate between @startdate , @enddate -- homecoming result of function homecoming isnull(@resultvar,0)

end

at line

sum([workingtime])/60

i result int. how convert or cast numeric or float..?

edit

i tried flowing:

sum(cast([workingtime] float))/60 sum([workingtime])/60.0

but no success.

well, can calculate float using

sum(cast([workingtime] float))/60

but need alter function homecoming value float:

returns float

sql sql-server-2008 sql-convert