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.