EVEN

Description

Round to next even number by rounding away from zero.

Syntax

EVEN(<a>)

Parameters

Parameter	Description
<a>	A numeric expression to round to the next even integer

Return Value

Returns an even integer based on the following rules:

• If x > 0, round up to the closest even number.
• If x < 0, round down to the closest even number.
• If x is already an even number, return it directly.
• If x is NULL, returns NULL.

Examples

select even(2.9);

+----------+
| even(2.9) |
+----------+
|        4 |
+----------+

select even(-2.9);

+-----------+
| even(-2.9) |
+-----------+
|       -4  |
+-----------+

select even(4);

+--------+
| even(4) |
+--------+
|      4 |
+--------+

select even(NULL);

+------------+
| even(NULL) |
+------------+
|       NULL |
+------------+