I have been using the stats avg(duration) as Avg_Duration in my query.But while displayin the Avg_Duration i am getting the output value with 6 decimal digits after the precision.Something like 2.123456 i would like to round it off to four digits only.Tried using the round function along with the stats command..but it didnt worked.
Please help me on this .Thanx
asked 30 May '12, 01:11
What have you tried already when you tried to round? Something like this works with my setup;
answered 30 May '12, 03:07