How to organize a withdrawal in one currency?

I

Ivan Antonov2015-02-19 14:00:06

MySQL

Ivan Antonov, 2015-02-19 14:00:06

There are offers in the database, each offer has a price and the currency in which it is indicated.
We also have the default currency and the exchange rate.
How to organize a withdrawal in the default currency, changing the prices at the specified exchange rate for offers with a price indicated in another currency?
I work with MySQL.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

Leonid Sysoletin, 2015-02-19
@sysoletin

Do you want to do this in MySQL?
Wouldn't it be easier to convert prices already when outputting?