convert Integer to Time - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

convert Integer to Time

Author

Topic

eugz
Posting Yak Master

210 Posts

Posted - 2009-07-21 : 14:32:05

Hi All.
I have data type integer of columns Hours and Minutes. How to convert those ineger column to time and SUM those column?
Thanks

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-07-21 : 14:42:17

Something like this?

declare @table table (hours int, minutes int)

insert into @table
select 10,50 UNION ALL
select 8,25 UNION ALL
select 3,26 UNION ALL
select 4,52 UNION ALL
select 3,31

SELECT [Hours] = sum(t.hours)+ sum(t.minutes)/60,[minutes] = sum(t.minutes)%60

FROM @table t

Jim