Format number to 2 decimal places

by

When formatting number to 2 decimal places you have two options TRUNCATE and ROUND. You are looking for TRUNCATE function.

Examples:

Without rounding:

TRUNCATE(0.166, 2)
-- will be evaluated to 0.16

TRUNCATE(0.164, 2)
-- will be evaluated to 0.16

docs: http://www.w3resource.com/mysql/mathematical-functions/mysql-truncate-function.php

With rounding:

ROUND(0.166, 2)
-- will be evaluated to 0.17

ROUND(0.164, 2)
-- will be evaluated to 0.16

docs: http://www.w3resource.com/mysql/mathematical-functions/mysql-round-function.php

More Related Contents:

  1. DOUBLE vs DECIMAL in MySQL
  2. CAST to DECIMAL in MySQL
  3. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  4. Why does MYSQL higher LIMIT offset slow the query down?
  5. How to split the name string in mysql?
  6. Normalization in MYSQL
  7. Is there a REAL performance difference between INT and VARCHAR primary keys?
  8. JOIN queries vs multiple queries
  9. how to compute similarity between two strings in MYSQL
  10. Timestamp with a millisecond precision: How to save them in MySQL
  11. Combine Multiple child rows into one row MYSQL
  12. sql join two table
  13. How to schedule a MySQL query?
  14. Is there a Profiler equivalent for MySql? [closed]
  15. Cast int to varchar
  16. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  17. Import SQL file into mysql
  18. MySQL SELECT last few days?
  19. “where 1=1” statement [duplicate]
  20. How do you debug MySQL stored procedures?
  21. Schrödingers MySQL table: exists, yet it does not
  22. MySQL Calculate Percentage
  23. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  24. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  25. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  26. Postgres LEFT JOIN with WHERE condition
  27. MySQL – Using COUNT(*) in the WHERE clause
  28. What’s mysql’s “BETWEEN” performance over..?
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment