Very Computer

What I want to do is essentially Concatenate
(Job_Length/60) & (Job_Length%60)

I keep getting this error:

Syntax error converting the varchar value ':' to a column
of data type int.

Here's my query in it's entirety...ANd I've tried Casting
every way imagineable (except probably the right way).  
Any help is seriously appreciated:

SELECT Department, Work_Type, Job_Number
        , Author_ID, Author_Name, Author_Date
        , Author_Time, Patient_SSN, (Job_Length  / 60)  
+':' +(Job_Length %60) as 'Job Length'
FROM Tbl_Job_Tracking Where Job_Number = '979075'

Quote:> SELECT Department, Work_Type, Job_Number
> , Author_ID, Author_Name, Author_Date
> , Author_Time, Patient_SSN, (Job_Length  / 60)
> +':' +(Job_Length %60) as 'Job Length'
> FROM Tbl_Job_Tracking Where Job_Number = '979075'

SELECT ... , CAST(Job_Length / 60 AS VARCHAR) + ':' + CAST(Job_Length % 60
AS VARCHAR(2)) ...

SELECT CONVERT( varchar , DATEADD( second , 247 , '' ) , 108 ) as 'hh:mm:ss'

Dinesh, SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com

Quote:> I am going NUTS.  I have a value, for instance 247 that's
> stored as an integer.  Anyway, I need my query to format
> it in Minutes/Second format....

> What I want to do is essentially Concatenate
> (Job_Length/60) & (Job_Length%60)

> I keep getting this error:

> Syntax error converting the varchar value ':' to a column
> of data type int.

> Here's my query in it's entirety...ANd I've tried Casting
> every way imagineable (except probably the right way).
> Any help is seriously appreciated:

> SELECT Department, Work_Type, Job_Number
> , Author_ID, Author_Name, Author_Date
> , Author_Time, Patient_SSN, (Job_Length  / 60)
> +':' +(Job_Length %60) as 'Job Length'
> FROM Tbl_Job_Tracking Where Job_Number = '979075'