TO_CHAR Local currency problem
927089Apr 6 2012 — edited Apr 7 2012Hi,
I'm trying to convert a number field to a char field so it displays on report as currency.
I am in the UK so i want the currency displayed as pounds (£) however it is diplaying in dollars ($)
It does this in SQL commands also so i doubt it is to do with the application.
This is how i have it in the query:
TO_CHAR(price_per_100g, 'L990.99') AS "Price Per 100g",
I'm just assuming it is to do with some setting, but i'm not sure how to fix it.
Any help would be much appreciated.