convert minutes to hours

Question

hi,

I want to convert minutes to hours. for example field_minutes=130minutes to 2:10 hours...

select field_minutes from table---> how can I do?

 

Answer 1

Not sure what this has got to do with SSIS but its an interesting little puzzle for a Friday afternoon anyway.

Paste the following into SSMS/QA and run it:

declare @mins int

set @mins = 130

select cast(@mins/60 as varchar(5)) + ':' + RIGHT('0' + cast(@mins%60 as varchar(2)), 2)

 

There are probably other, better, ways!!!

 

-Jamie