Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TO_CHAR Local currency problem

927089Apr 6 2012 — edited Apr 7 2012
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2012
Added on Apr 6 2012
8 comments
683 views