Posted by Ed Murphy on 10/04/07 02:30

tatata9999@gmail.com wrote:

> SUM(CASE WHEN (datediff(n,start,stop)/60 > 0)
> THEN (datediff(n,start,stop)/60) End) as
> total_hours
> returned summary/calculated about right, but it's at hour level, so,
> 0.45 minutes would be discarded, not very good

CASTing datediff() to some appropriate DECIMAL type should take
care of it.

[Back to original message]