strife's devLog

Month: February, 2012

mysql-logoMySQL: 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:

See ya!