SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format
- by Pinal Dave
Here is another question I received via email.
“Hi Pinal,
I have a unique requirement. We measure time spent on any webpage in measure of seconds. I recently have to build a report over it and I did few summations based on group of web pages. Now my manager wants to convert the time, which is in seconds to the format Hour : Minute : Seconds. I…