Want to change time on Tickets Closed report to just display total hours and not days, minutes or seconds
08/01/2018 244 views
I tend to do alot of Pivot Table work and produce charts. For my small org, time to close should really just be reported in hours and not broken into Days, minutes, seconds. I now modify this once I have the report in Excel, because I know how to do so. I don't know how to do this with SQL. I believe this is the relevant part of the report query. Can anyone give me the proper syntax do get this to report in just hours?
TO_DAYS(HD_TICKET.TIME_CLOSED) - TO_DAYS(HD_TICKET.TIME_OPENED),
TO_DAYS(HD_TICKET.TIME_CLOSED) - TO_DAYS(HD_TICKET.TIME_OPENED) - 1), 'd ',
'%kh %im')) AS TIME_TO_CLOSE,
Answer Chosen by the Author
Please log in to answer
timestampdiff(HOUR, HD_TICKET.CREATED, HD_TICKET.TIME_CLOSED) AS "Time to Close"
Answered 08/02/2018 by: chucksteel