I have a SQL query with the following line in it to calculate the total number of hours worked by an employee, based on the times the employee clocked in and out of the building. The calculation produces a result of type "varchar". How can I get it to produce a result of type "decimal"?
the query is below"
convert(varchar(10), dateadd(second, sum(datediff(second, ClockIn, ClockOut)), 0), 108), "