Built-In Functions and Syntax › Next Integer Equal or Lower

Next Integer Equal or Lower

The next integer equal or lower function returns the largest integer that is equal to or less than a numeric value.

Syntax:

►►─┬─ NEXIL ─────────┬─ (value) ──────────────────────────────────────────────►◄
   ├─ @INT ──────────┤
   ├─ @TRUNC ────────┤
   ├─ NEXTINEL ──────┤
   └─ NEXT-INT-EQLO ─┘

Invocation names:

@INT
NEXIL
@TRUNC
NEXTINEL
NEXT-INT-EQLO

Parameters:

(value)

Specifies the numeric value to be rounded down to the next integer.

Example:

This example rounds a balance due amount to the next lower dollar value. The initial value of BALANCE-DUE is 453.29.

select nexil(balance-due) as 'balance-due' from invoice

  BALANCE-DUE = 453