$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.
Syntax
$MOD(<column-spec|expression|constant>,<column-spec|expression|constant>)
n
Required. This can be a column, expression, or constant.
y
Required. This can be a column, expression, or constant.
Example
select orders_year, $MOD(order_year, 4) from orders
ORDER_YEAR
-------------- |
$MOD(ORDERS.ORDER_YEAR,4)
-------------------------- |
2003 |
3 |
2002 |
2 |
...
Top
|