dividing a smallint datatype - 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

SQL Server 2000 Forums

Transact-SQL (2000)

dividing a smallint datatype

Author

Topic

chippyles
Yak Posting Veteran

68 Posts

Posted - 2006-08-04 : 10:49:00

I have a column named nRUN_TIME that is a smallint. the numbers in this colum are minutes a product ran. so on an average it is anywhere between 84 and 130 minutes. I need to divide this number by 1440 to give me the fraction of a day. for example, I have one record at 136 minutes and I need the results to be 0.094 after I divide it by 1440. If I do this in SQL the number comes out to 0. I tried to convert nRUN_TIME to a decimal and a numeric, but it either gives me errors or I still get a 0. What can I do in this situation?

Thanks!!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-08-04 : 10:52:07

[code]declare @nRUN_TIME smallint

select @nRUN_TIME = 136

select @nRUN_TIME / 1440 -- 0

select @nRUN_TIME * 1.0 / 1440 -- 0.094444

select convert(decimal(10,3), @nRUN_TIME * 1.0 / 1440) -- 0.094
[/code]