Operand data type time is invalid for avg operator...?

Viewed 12490

How can I avg(time(4)) in the following query:

  select top 10 avg(e.Duration) from TimeTable e

I'm getting the following error:

Operand data type time is invalid for avg operator.

Duration is type time(4) such as:

Duration
-------------
00:00:10.0000
4 Answers
Related