Hi there.

Im storing "minutes" as a decimal(9,2) in a ms sql db. However, I need to see the data as "decimal" hours.

EG: 75mins = 1.25

If i do a Select minutes / 60 I just get a 1.00

oops, fixed (dam cold!)

declare @h as decimal(9,2)
set @h = 71.00
set @h = @h / 60
print @h

What reason do you have for keeping minutes in a decimal form like that ?

the same reason your mum needs a cock in her

"cos she wants it"

Use a DATETIME.

What reason do you have for keeping minutes in a decimal form like that ?

calculating payrolls. its a computed column based on start and finish times.

Can't you just do "/ 60.0" instead of "/ 60". Can't remember for sure but thought that worked because both values were decimals so result was too.

sql2008 has time, if you've got the time to wait for that.

calculating payrolls. its a computed column based on start and finish times.

Why would you need a computed column for something that simple, if you're already stored start and finish time (presumably in date/time data type) ? You can just calculate the hours on the fly without having to use either trigger or calculation in your app?

I mean it's a simple matter of just use a DATEDIFF(n, start, end)/60.00, that'll give you exactly what you wanted. ?

Unless you've created a calculated column for some special reason like you index it for something? I mean if you're doing some Data Warehousing that needs to do a range look up to build your fact table then it'd make more sense to store such simple values.

Can't you just do "/ 60.0" instead of "/ 60". Can't remember for sure but thought that worked because both values were decimals so result was too.

Yes you can. SQL will implicitly convert the data to 1 decimal.