Home Forums Article Discussions Article Discussions by Author Discuss content posted by wfvdijk Convert seconds to a timestring RE: Convert seconds to a timestring
nigel.
SSChampion
Points: 11636
More actions
May 5, 2010 at 8:31 am
#1162493
An alternative, using DATEADD and CONVERT
select CONVERT (varchar(8),DATEADD(second,@duration,0),114)
NigelHow to post questions