what is wrong with my query?

[ii128]

SELECT name, datediff("s", start_time, stop_time) /3600, count(name)
FROM usertime group by name

Help!!!! what is wrong with my query?

 

[tlbroadbent]

Remove the " around the s in the datediff function when using T-SQL in SQL Server. You should add a decimal to the 3600 to calculate fractions of hours.

I would also add an alias for the calculated time and count.

SELECT
name,
datediff(s, start_time, stop_time) / 3600. As Hours,
count(name) As Cnt
FROM usertime
GROUP BY name Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.