T round(T x[, d]) Rounds the argument x to d decimal places. d defaults to 0 if not specified. If d is negative, the left d digits of the decimal point are 0. If x or d is null, null is returned. 2.5 will round up to 3. If you want to round down to 2, please use the round_bankers function.
:::tip Another alias for this function is dround. :::
mysql> select round(2.4); +------------+ | round(2.4) | +------------+ | 2 | +------------+ mysql> select round(2.5); +------------+ | round(2.5) | +------------+ | 3 | +------------+ mysql> select round(-3.4); +-------------+ | round(-3.4) | +-------------+ | -3 | +-------------+ mysql> select round(-3.5); +-------------+ | round(-3.5) | +-------------+ | -4 | +-------------+ mysql> select round(1667.2725, 2); +---------------------+ | round(1667.2725, 2) | +---------------------+ | 1667.27 | +---------------------+ mysql> select round(1667.2725, -2); +----------------------+ | round(1667.2725, -2) | +----------------------+ | 1700 | +----------------------+
ROUND, DROUND