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)
 Convert Seconds

Author  Topic 

whitmoj
Yak Posting Veteran

68 Posts

Posted - 2008-12-01 : 09:31:53
Can any one advise how to convert seconds (stored as a decimal) to hours min's and sec's

Whitmoj
If you are in a hurry you will never get there

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-01 : 09:36:07
[code]SELECT secvalue/3600 as hours,(secvalue%3600)/60 as minutes,(secvalue%3600)%60 as seconds from yourtable[/code]
Go to Top of Page

whitmoj
Yak Posting Veteran

68 Posts

Posted - 2008-12-01 : 10:11:27
Many Thanks

Whitmoj
If you are in a hurry you will never get there
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-01 : 10:25:19
Cheers
Go to Top of Page
   

- Advertisement -