Advertisement

07.09.2008 at 06:12AM PDT, ID: 23550020
[x]
Attachment Details

cast seconds as minutes and seconds or as fractional minutes

Asked by charlesbaldo in SQL Server 2005, MS SQL Server

Tags: microsoft, sql server, 2005

SQL server 2005 TQL

I have a value that is a total number of seconds
I want to cast (or calcualte it) it as minutes and seconds. Prefereable as a fraction so 90 seconds would be 1.5 minutes, 75 seconds would be 1.25 minutes
Start Free Trial
[+][-]07.09.2008 at 06:18AM PDT, ID: 21963212

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.09.2008 at 06:18AM PDT, ID: 21963219

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server
Tags: microsoft, sql server, 2005
Sign Up Now!
Solution Provided By: BrandonGalderisi
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.09.2008 at 06:41AM PDT, ID: 21963419

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628