Hi folks: This question could be innapropiate but this list has always been great . Besides I'm a newbie. My problem is Transact-SQL related. I want to convert a numeric value (it 's the amount of seconds a user has spend in one of my sites) to this format hh:mm:ss .Is there any function in SQL transact that I could use ??. Any piece of advice should be appreciated. regards Mario
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com