InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:23:13 GMT20http://www.sqlservercentral.com/Forums/Topic913275-1009-1.aspx[quote][b]Wilfred van Dijk (5/5/2010)[/b][hr]WOW! :w00t::w00t: that was an easy one! Sometimes you're working on a solution which can be replaced by a very few lines ( I feel stupid :ermm::ermm::ermm: )Have a drink from me![/quote]Thanks for the feedback, glad to have contributed something useful.Now, about that drink ... :-)Thu, 06 May 2010 02:33:46 GMTnigel.http://www.sqlservercentral.com/Forums/Topic913275-1009-1.aspx[quote][b]robshobs (5/5/2010)[/b][hr]Keep in mind that this only works up to 23:59:59. Anything greater than or equal to 24 hours (86,400 seconds) will not work. I have reports were we show some records with more than 24 hours and had to write a custom function.[/quote]Excellent point, thanks.Thu, 06 May 2010 02:30:04 GMTnigel.http://www.sqlservercentral.com/Forums/Topic913275-1009-1.aspxKeep in mind that this only works up to 23:59:59. Anything greater than or equal to 24 hours (86,400 seconds) will not work. I have reports were we show some records with more than 24 hours and had to write a custom function.Wed, 05 May 2010 13:04:33 GMTrobshobshttp://www.sqlservercentral.com/Forums/Topic913275-1009-1.aspxWOW! :w00t::w00t: that was an easy one! Sometimes you're working on a solution which can be replaced by a very few lines ( I feel stupid :ermm::ermm::ermm: )Have a drink from me!Wed, 05 May 2010 09:06:25 GMTWilfred van Dijkhttp://www.sqlservercentral.com/Forums/Topic913275-1009-1.aspxAn alternative, using DATEADD and CONVERT[code="sql"]select CONVERT (varchar(8),DATEADD(second,@duration,0),114)[/code]Wed, 05 May 2010 08:31:28 GMTnigel.http://www.sqlservercentral.com/Forums/Topic913275-1009-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/70134/">Convert seconds to a timestring</A>[/B]Thu, 29 Apr 2010 14:39:41 GMTWilfred van Dijk