Question : truncate your answer to decimal places mysql
Answered by : simarjeet-singh
SELECT TRUNCATE(135.375, 2); -- Result: 135.37
SELECT TRUNCATE(COLUMN_NAME, X) FROM TABLE;
-- Truncate values in the COLUMN_NAME upto X decimal places
Source : | Last Update : Wed, 06 Jul 22