|
|
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.
Navigation:
[Reply to this message]
|