Please a quick question. I am getting ready a new Scheduler task to send a mail with a summary that includes quantities/values of type “currency”. They are shown in the right way we need in the user interface with our “locale” configuration however in the DB for example the 500,00€ that it is shown in the Detail View, it is stored in the table as “500.00”.
Is there any way that after obtaining this value 500.00 in a SQL query in our custom code, I can, somehow, the global $locale variable to apply the configuration we have and be able to use the string “500,00€” in the mail that I am building in this process.
Thanks so much!