returning a decimal value from an epression

[deharris2003]

OK i am still new at SQL and my probelm is that when I divide Minutes by 60 (I.E. 458 minutes divided by 60 should return 7.63 hours) However When I do SUM(MINS)/60 I get 7. I tried CAST((SUM(MINS) / 60) as float) As hours and I still get 7. Can anyone tell me how to get SQL to return 7.63 instead of 7?

 

[AtomicWedgie]

CONVERT(DECIMAL(18,2),(SUM(MINS)/60)))

 

[AtomicWedgie]

oeps, DECIMAL doesn't work

 

[AtomicWedgie]

It should be like this SUM(MINS)/60.00

Regards,

Atomic Wedgie

 

[SQLSister]

IS minutes an integer datatype? YOu need to cast or convert just the minutes part of the equation first. An integer divided by anything will always give you an integer result.

CONVERT(DECIMAL(18,2),(SUM(MINS))/60.00