Viewing post 1 (of 2 total)
Try using the following straight in you dataset for your report:-
SELECT CONVERT(CHAR(8), DATEADD(SECOND,convert(int, @Seconds), '00:00:00'), 108)
Had to convert the 2nd DATEADD argument to INT else an error was thrown
April 16, 2008 at 5:43 am
#803003