TRUNC(numeric_value[,precision] )
Argument | Required/ Optional | Description |
---|---|---|
numeric_value | Required
| Numeric datatype. Passes the values you want to truncate. You can enter any valid transformation expression that evaluates to a Numeric datatype.
|
precision | Optional
| Can be a positive or negative integer. You can enter any valid transformation expression that evaluates to an integer. The integer specifies the number of digits to truncate.
|
TRUNC ( QTY / 15 )
TRUNC ( 15000000 * (1/15) TRUNC ( 15000000 * (1/15) = TRUNC ( 15000000 * 0.0666666666666666) = TRUNC ( 15000000 * 0.0666666666666666) = TRUNC ( 999999.99999999) = 999999
TRUNC (ROUND (QTY/15, .99999999999999999999999999)).
TRUNC( PRICE, 3 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
TRUNC( PRICE, -1 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
TRUNC( PRICE )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|