Omnidex SQL Function: $MOD

Returns “n modulus y”. This is the remainder of n divided by y.

“n” and “y” may be a column , expression, or literal.

The return value is INTEGER length 4.

$MOD(<column-spec|expression|constant>,<column-spec|expression|constant>)

Required. This can be a column, expression, or constant.

Required. This can be a column, expression, or constant.

select orders_year, $MOD(order_year, 4) from orders

ORDER_YEAR

$MOD(ORDERS.ORDER_YEAR,4)

2003

3

2002

2

…