floor(X)
Returns the largest integer less than or equal to the given value. The result is a decimal data type.
Syntax
floor(X)
Input
Argument | Type | Description |
---|---|---|
X |
any numeric type | A numeric value |
Return Value
Returns a decimal value corresponding to the largest integer less than or equal to
X
.
If X
is N/A, the result is N/A.
Sample Usage
X |
floor(X) |
---|---|
-5.25 | -6 |
-5.0 | -5 |
13 | 13 |
4.5 | 4 |
5.0 | 5 |
NA | NA |
Example
In this example, the floor(X)
function returns the largest integer less
than or equal to the value of sales
on the
pub.demo.retail.item
table. The new column contains decimal data type
values.
<base table="pub.demo.retail.item"/> <colord cols="transid, account, store, date, sku, sales"/> <willbe name="floorsales" value="floor(sales)"/>