Predefined Parameters
This section describes the predefined parameters added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open source edition.
| Predefined Parameter | Description |
|---|---|
| NLS_DATE_FORMAT | Defines the date format. |
| NLS_DATE_LANGUAGE | Defines the date language. |
| NLS_DUAL_CURRENCY | Defines the local currency symbols for the currencies of specific territories or countries. |
| NLS_CURRENCY | Defines the currency symbol. |
| NLS_TIME_FORMAT | Defines the time format without the time zone. |
| NLS_TIME_TZ_FORMAT | Defines the time format without the time zone. |
| NLS_TIMESTAMP_FORMAT | Defines the timestamp format without the time zone. |
| NLS_TIMESTAMP_TZ_FORMAT | Defines the timestamp format with the time zone. |
| NLS_NUMERIC_CHARACTERS | Defines the characters used as group separator and decimal character. |
| NLS_ISO_CURRENCY | Defines the ISO currency symbols for the currencies of specific territories or countries. |
| NLS_TERRITORY | Resets the values of NLS_CURRENCY, NLS_ISO_CURRENCY, and NLS_NUMERIC_CHARACTERS based on the regional currency and displayed number format. |
| NLS_LANGUAGE | Defines the default language of the database. |
| NLS_LENGTH_SEMANTICS | Defines the default length semantics of character strings. The value is BYTE or CHAR. |
| NLS_SORT | Defines the collating sequence for local characters. |
| NLS_COMP | Defines the collation behavior of database sessions. |
Last Article: Implicit Type Conversion
Next Article: Macro Variables
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.