convert minutes to hours

Fri, 24 Feb 2006 15:26:44 Z

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?

Fri, 24 Feb 2006 15:42:57 Z

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