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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
