Built-in Functions → trunc

trunc() is a scalar arithmetic function that evaluates an expression and returns the whole number portion of a double by truncating any fractional part.

Signature

Copy
trunc(double exp)

• double exp: expression returning double

Returns

double with no fractional part

Example

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

Copy
trunc(Sales_Acme.Sales.AMOUNT_SOLD)