Updating View

[forces]

I have a question, I created a view age with the command: create view age as select username, datediff(curdate(),birthday)/365.25 as age from users;

however it currently prints by default 5 decimal places, where the file type is decimal(16,5) .. how can I alter the view to only show age 19, age 20, etc.

[stewartship]

use the function intval() on the output to force the decimal to be output as an integer eith no decimal places