Convert Float to Time Stamp with No Date and must return days as hours - URGENT
Posted on 2008-10-23
I have field in a table which is Float, it contains a Duration Value.
I need this to be returned as a Time Value.
For Example I can get it to return as a TIme Stamp....as Below using 108 or 114
which gives me HH:MM:SS:mmm
select convert(Varchar,CAST(NetDur AS DATETIME),108)as NetDur
Result looks like : 00:11:27:997
But if I look at this value using
select convert(Varchar,CAST(NetDur AS DATETIME),120)as NetDur
Result looks like : 1900-01-03 00:11:27
So actually my duration is 3 days, eleven mins and twenty seven seconds.....
I need my time stamp to then include the number of days in hours....
so it should be 72 hours.....
I need the result to be 72:11:27:997
This value as float is displayed as 2.00796296296296 of which I've attempted my convert on.
Please can someone help this is URGENT.