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.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2012

Added on Apr 6 2012

#apex-discussions

8 comments

686 views