Tag: mysql
MySQL: How to Round Prices to Nine Ninety Nine at the end (9.99)
Hi there,
Here’s the example how to round values to 9.99 at the end. For example if we have a price 45023.12 and we wanna change it to 45029.99, we should simple use this code:
|
1 |
SELECT CONCAT(LEFT(ROUND(YOUR_PRICE, 0), CHAR_LENGTH(ROUND(YOUR_PRICE, 0)) - 1), '9.99'); |
See ya!
