Latest Posts

Convert Seconds to Hour: Minute: Seconds Format in Sql Server

 Admin   
86 View    Nov 16 2020 5:45PM

I have a database column containing an integer value that represents a systems up time in seconds. I'd really like a query to be able to show me that up time in a easy to read format day(s) hour(s) minute(s) but I'm not quite sure how to do it. A lot of examples I've found appear to use parameters as an example but never much of how to use it in a select function.

Read More..


convert seconds to hh:mm:ss format in sql

 Admin   
71 View    Nov 16 2020 5:38PM

I have a database column containing an integer value that represents a systems up time in seconds. I'd really like a query to be able to show me that up time in a easy to read format day(s) hour(s) minute(s) but I'm not quite sure how to do it. A lot of examples I've found appear to use parameters as an example but never much of how to use it in a select function.

Read More..