How to round 4600 to 4500 and 4450 to 4000 in mysql?
try:
ROUND((``price``,-3),TRUNCATE(``price``,-2.5)
example:
13650 To 13500 and 20475 To 20000
Asked
Active
Viewed 75 times
0
Korosh Man1989
- 43
- 6
-
This is basic arithmetic. – Strawberry Jan 22 '18 at 14:29
-
what?not clear. – Korosh Man1989 Jan 22 '18 at 14:30
-
3`SELECT FLOOR(13650/500)*500 n;` – Strawberry Jan 22 '18 at 14:31
-
https://stackoverflow.com/questions/36843808/mysql-round-half – Martijn Jan 22 '18 at 14:32