Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
how to just get time from a date
hello
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.
What i get
what i need
my SQL
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.
What i get
1900-01-01 00:00:55.000
what i need
00:00:55
my SQL
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) )
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
but this line is the line I need in just hours minutes sand seconds call time returns the correct result i need
this is the line i need to remove the default date from.
this is the line i need to remove the default date from.
DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', convert(varchar(10), dateadd(second, Duration, 0), 108))), '00:00:00.000') as time
I think you can just do this and get the desired result, if I'm reading the code correctly:
Select datediff(hour, 0, cast(CallTime as time)),
CAST(DATEADD(SECOND, SUM(Duration), 0) AS time) 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) )
Select datediff(hour, 0, cast(CallTime as time)),
CAST(DATEADD(SECOND, SUM(Duration), 0) AS time) 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) )
Premium Content
You need an Expert Office subscription to comment.Start Free Trial