All mathematical functions return NULL in the event of an error. ABS( X ) ..... ROUND() uses the following rules depending on the type of the first argument:.
dev.mysql.com