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.
| Author |
Topic |
|
mtmaedjaja
Starting Member
2 Posts |
 Posted - 2009-06-19 : 10:52:22
|
| I've searched high and low for this and cannot seem to find a legit answer. I have data in seconds (ex. 6547 seconds) and want to output the same seconds but in decimal time (ex. 5400 seconds = 1.5 hours). I can get it to display in hh:mm:ss format but not in decimal time. Anybody have any ideas?Thank you so much! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-19 : 11:58:02
|
For example: select 5400/60.0/60.0
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
mtmaedjaja
Starting Member
2 Posts |
Posted - 2009-06-19 : 14:36:47
|
| awesome, thanks webfred. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-19 : 15:00:38
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
convert seconds to decmial time