Posted by Ed Murphy on 10/05/07 00:59

tatata9999@gmail.com wrote:

> On Oct 3, 9:30 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
>> tatata9...@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.
>
> I've tried DECIMAL(1) and (2) respectively to no avail. Do you have a
> sample one? Thanks.

Try DECIMAL(10,2) and see how that works for you.

[Back to original message]