You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


trunc

Returns the whole number portion of a double.

Example

Remove the fractional portion from the values in the AMOUNT_SOLD column.

trunc(Sales_Acme.Sales.AMOUNT_SOLD)

Syntax

trunc(double expr x)
  • x : expression returning double

    Returns

    double with no fractional part

Notes

Function trunc evaluates its expression argument and truncates any fractional part.


© Incorta, Inc. All Rights Reserved.