TRUNC
Returns the number x truncated to d decimal places. This is similar to the TRUNCATE function except that the precision (d) is not required.
If the precision is not specified, the number is truncated to 0 decimal places.
Note
If you do not specify a format, and if your value is not numeric, it will be treated like a date.
Syntax
TRUNC(x [,d])
Arguments
x: the number to be truncated
d: the number of decimal places
Return Type
Float or double.
Examples
SELECT TRUNC(PI()); **** +-------------+ | TRUNC(PI()) | +-------------+ | 3 | +-------------+
SELECT TRUNC(42.422, 1); **** +------------------+ | TRUNC(42.422, 1) | +------------------+ | 42.4 | +------------------+