MySQL TRUNCATE() Function
MySQL TRUNCATE() Function
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);
MySQL TRUNCATE() Function
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);