I am just trying to get a time from the query I have and its giving me the default date then my time. The time is the only part that I need in that field.
select datediff(hour, 0, cast(CallTime as time)), DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', convert(varchar(10), dateadd(second, Duration, 0), 108))), '00:00:00.000') as time from NT_API_CallLogs WHERE Duration <> 0 AND cast(CallTime as date) = '2017-3-08'GROUP BY datediff(hour, 0, cast(CallTime as time) )ORDER BY datediff(hour, 0, cast(CallTime as time) )