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

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.

trunc(Sales_Acme.Sales.AMOUNT_SOLD)