Databases Reference
In-Depth Information
and D that defines the Group (G) separator and the Decimal (D) separator. The
TO CHAR
function also
accepts NLS parameters.
For example
to char(123.45,'999D99','NLS NUMERIC CHARACTERS = ''.,''')
will display the
number 123.45 with the appropriate decimal notation depending on the territory defined in the APEX
session. For the Currency format, the following should be used:
FML999G999G999G990D00
. The FML format
will display the correct currency symbol depending on the territory of the session. Keep in mind that this
only formats the number and that there are no automatic processes available to convert the amounts
based on currencies and localization in APEX. To convert an amount to a different currency, a process
has to be programmed in order to get the currency conversion rate and apply it to the amount.
The session
NLS DATE FORMAT
,
NLS TIMESTAMP FORMAT
, and
NLS TIMESTAMP TZ FORMAT
are set in the
Globalization attributes of the Shared Components of the application, as shown in Figure 5-23.
Figure 5-23.
Application date formats
Time Zones and Territories
To demonstrate the time zone and territory localization features in APEX, we built a simple application.
In the example shown in Figure 5-24, we are running our application in Canada, localized in Montreal.
You can see that the time zone is Greenwich -5 ,the currency sign is $, and the decimals indicator is
represented by a comma which is the locale standard for that region.
Figure 5-24.
Example application for Time Zones and Territories
