I wonder if you can help me.

I'm creating a stroed procedure in SQL Server 7 to allow users to view an online telephone bill.

My problem is that the duration of the call is in seconds, and I want to display it in Hours, Minutes and Seconds.

e.g. 1801 seconds -> 0:30:01

Is there some code that can help me to perform this from within the stored procedure?

Thanking you in advance.