Converting data field into hours, minutes, seconds.
T/SQL, SQL Server 2005
How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds? Question
T/SQL, SQL Server 2005
How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
declare @seconds int, @minutes int, @hours int
set @seconds = 56132156
set @hours = @seconds / 3600
set @seconds = @seconds - (3600*@hours)
set @minutes = @seconds / 60
set @seconds = @seconds - (60*@minutes )
select @hours, @minutes, @seconds
Browse more Questions and Answers on SQL Server.
Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Mrdenny | Jul 10 2008 4:46PM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
