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 the smallest even integer that is greater than or equal to x when x > 0, or less than or equal to x when x < 0.

Examples

select even(2.9);

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

select even(-2.9);

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

select even(4);

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