![]() ![]() I would have to have some kind of cron job to daily update this table. Goto SE11 and search for the following tables regarding currencies. Also, view Rand to Dollar currency charts. The table to view the exchange rates is TCURR. ![]() Compare money transfer services, compare exchange rates and commissions for sending money from South Africa to United States. To see a currency chart, select your two currencies, choose a time frame, and click to view. All charts are interactive, use mid-market rates, and are available for up to a 10-year time period. GBPGBP (well i guess i can probably avoid this one if a slighty amend the query to detect this scenario) Convert South African Rands to American Dollars with a conversion calculator, or Rands to Dollars conversion tables. Xe Currency Charts With this convenient tool you can review market history and analyse rate trends for any currency pair. Note that on the above tables I would have to have every single combination GBPEUR ![]() JOIN exchange_rate er ON er.currency_code_from=(the currency of the item) AND er.currency_code_to=(the user currency). dollars using the applicable exchange rate without prior notice to you. I would then write a query like: select price as originalPrice, (price * rate) as TargetPrice FROM. Incoming wire transfers received in a foreign currency for payment into your account will be converted into U.S. PRIMARY KEY (currency_code_from, currency_code_to),įOREIGN KEY (currency_code_from) REFERENCES currency(code) ON DELETE CASCADE,įOREIGN KEY (currency_code_to) REFERENCES currency(code) ON DELETE CASCADE Updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, So I think I'm going to store all the exchanges rate in the DB and have my query do the conversation job here is my first draft: CREATE TABLE currency (Ĭreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, But I'd rather not have to unnecessarily loop if I can directly get the right price form the query. I'm working with Java and my first thought was that I would use some kind of API to pull the rates and post process (loop) after I get the the items from the DB. I'm working on a small project and I'm have arrived to the point where I let a user chose in which currency to display items. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |