CAST to DECIMAL in MySQL

by

From MySQL docs: Fixed-Point Types (Exact Value) – DECIMAL, NUMERIC:

In standard SQL, the syntax DECIMAL(M) is equivalent to DECIMAL(M,0)

So, you are converting to a number with 2 integer digits and 0 decimal digits. Try this instead:

CAST((COUNT(*) * 1.5) AS DECIMAL(12,2))

More Related Contents:

  1. Format number to 2 decimal places
  2. Cast int to varchar
  3. DOUBLE vs DECIMAL in MySQL
  4. How can I cast an int to a bit in MySQL 5.1?
  5. Which DB technology is sued to solve the following search issue? [closed]
  6. How do you set a default value for a MySQL Datetime column?
  7. Storing image in database directly or as base64 data?
  8. Implementation of Levenshtein distance for mysql/fuzzy search?
  9. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  10. MySQL – Operand should contain 1 column(s)
  11. Restore table structure from frm and ibd files
  12. Can a number be used to name a MySQL table column?
  13. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  14. mysql pivot/crosstab query
  15. UNION query with codeigniter’s active record pattern
  16. When to use MongoDB or other document oriented database systems? [closed]
  17. Remove Primary Key in MySQL
  18. MySql views performance [closed]
  19. When to use NULL in MySQL tables
  20. What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
  21. Detecting locked tables (locked by LOCK TABLE)
  22. How to get size of mysql database?
  23. MySQL CURRENT_TIMESTAMP on create and on update
  24. Calculating time difference between 2 dates in minutes
  25. Access denied after setting user’s password with SHA256 in phpMyAdmin
  26. connecting MySQL server to NetBeans
  27. Join two tables (with a 1-M relationship) where the second table needs to be ‘flattened’ into one row
  28. MySQL: How do I use delimiters in triggers?
  29. Array data type, split string,
  30. How can I make a table in MySQL called “order”?

Leave a Comment