Example
Return a number truncated to 2 decimal places:
SELECT TRUNCATE(135.375, 2);
Definition and Usage
The TRUNCATE() function truncates a number to the specified number of decimal places.
Return a number truncated to 2 decimal places:
SELECT TRUNCATE(135.375, 2);
The TRUNCATE() function truncates a number to the specified number of decimal places.