$NLS_FORMAT
Set the default behavior for displaying data of type Number, Float, Date, Time, and Datetime.
$NLS_FORMAT {
=
} nlslocale
| classic
Arguments
nlslocale
—use the value specified by $NLS_LOCALE. If $NLS_LOCALE is set tosystem
or a locale, data of type Number, Float, Date, Time, and Datetime is displayed according to the current locale.classic
—ignore the locale when displaying locale-sensitive data
Defaults
Assignment file: | All |
Section: | [SETTINGS] |
Default value: | nlslocale
|
Description
Use $NLS_FORMAT if you want the default behavior for data formatting to be different than $NLS_LOCALE.
If $NLS_LOCALE is set to system
or a locale, locale-based formatting is applied.
Locale Code | Locale | Currency and Numeric Separators | Date | Time |
---|---|---|---|---|
en_US | English (United States) | $12,345.67 | Wednesday, December 2, 2009 | 4:08:42 PM |
en_GB | English (United Kingdom) | £12,345.67 | Wednesday, 2 December 2009 | 16:08:42 |
fr_FR | French (France) | 12 345,67 € | mercredi 2 décembre 2009 | 16:08:42 |
fr_CA | French (Canada) | 12 345,67 $ | mercredi 2 décembre 2009 | 16:08:42 |
nl_NL | Dutch (Netherlands) | € 12.345,67 | woensdag 2 december 2009 | 16:08:42 |
ja_JP | Japanese (Japan) | ¥12,346 | 2009年12月2日水曜日 | 16:08:42 |
bg_BU | Bulgarian (Bulgaria) | 12 345,67 лв. | 02 декември 2009, сряда | 16:08:42 |
Setting the value of $nlsformat in ProcScript overrides the value of $NLS_FORMAT, if defined, in the assignment file.