roy thakur
February 12th, 2002, 05:09 AM
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.
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.