I need to convert an interger to mm:ss. The value, duration, is stored in seconds as an int, 123456. This should be translated as 123.456 seconds. On select I need to convert that to mm:ss. For my purposes I can truncate everything to the right of the decimal. Is dateadd the right approach here? I'm not an SQL expert, just a weeny writing reports. Thanks for any help you can provide.

Jamie

?
select right(convert(char(8),dateadd(ss,123456/1000,''),108),5)

This work! Thank you.