N
N
Nikita2018-08-23 18:58:00
SQL
Nikita, 2018-08-23 18:58:00

What SQL query to do to round prices up to 90?

Hello. It is necessary to round all prices on the site to 90. Let's say there is such a price in the database 1354.5000, how to round it up to 1390.0000? Or there is such a price as 245664.0000, and this price should also be rounded up to 245690.0000. I think you understand. Google did not help or I did not search well, sorry, I did not find it. Thank you in advance.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artem Spiridonov, 2018-08-23
@customtema

Perhaps my answer is off topic, but still I would not do it at the database level, but would implement it at the business logic level.
Are there many entries? What are the rules for updating?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question