cool - never seen that syntax before. -mk
-----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:55 AM To: CF-Talk Subject: Re: TSQL Quoting Mario Martinez <[EMAIL PROTECTED]>: > > 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 ??. Why not use plain old SQL? SELECT EXTRACT('hour', INTERVAL 'your_number SECOND') || ':' || EXTRACT('minute', INTERVAL 'your_number SECOND') || ':' || EXTRACT('second', INTERVAL 'your_number SECOND'); Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
