mysql sum转为整数,在SQL中选择/转换输出为整数

I'm working on a site that requires me to display a graph of the average number per day of a user input. I have a SQL query already that returns this info to me:

SELECT sum(number)/count(number) as average, date FROM stats WHERE * GROUP BY date

This gives me the result I am looking for, but the result is given with three decimals precision. I want to round of this number. I could do it in PHP or my template engine, of course, but I was curious if there was a way to do this all in the database.

Is there a way to cast an output as an integer (in MySQL)?

解决方案SELECT

CAST(sum(number)/count(number) as UNSIGNED) as average,

date

FROM stats

WHERE *

GROUP BY date