Mega Code Archive

 

Categories / MySQL Tutorial / Math Numeric Functions

 

SELECT TRUNCATE(545,-2)

mysql> mysql> SELECT TRUNCATE(545,-2); +------------------+ | TRUNCATE(545,-2) | +------------------+ |              500 | +------------------+ 1 row in set (0.00 sec)