integer to HH:MM:SS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

integer to HH:MM:SS

Author

Topic

noamg
Posting Yak Master

215 Posts

Posted - 2005-03-16 : 05:27:45

declare @startDate datetime
set @startDate = '03/13/2005 01:00:00'

declare @endDate datetime
set @startDate = '03/13/2005 02:22:40'

SELECT @result= DATEDIFF( second, @startDate , @endDate )
I need to show the result as hh:mm:ss
how to do ?

Noam Graizer

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-03-16 : 05:40:21

Try this

declare @startDate datetime
set @startDate = '03/13/2005 01:00:00'

declare @endDate datetime
set @endDate = '03/14/2005 02:22:40'
declare @result integer
SELECT @result= DATEDIFF( second, @startDate , @endDate )
select convert(varchar(5),@Result/3600)+':'+convert(varchar(5),@Result%3600/60)+':'+convert(varchar(5),(@Result%60))

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources