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 |
+------------+