Convert Int value of seconds into a Time Stamp
Posted on 2008-10-24
I have an Int field containing seconds that I need to convert into a Time Stamp.
I have managed to select
Select CONVERT(char(8), DATEADD(second, ActualDuration, ''), 108)
But it does not give me a 24 hour clock in the sense that if I have a value of 173690
it is displaying as 00:14:50
This is incorrect.
I need it to add on 24 hours per day, so if the int values of seconds goes into days I need the time stamp to display 48:00:00 for example when it's been 2 days.
Help would be appreciated....