nls_date_language

Last Updated:2026-09-03 07:23:57

Note

This variable was introduced in V2.2.77.

Description

nls_date_language specifies the default date language of the information entered or returned by TO_DATE and TO_CHAR, including date, month, am/pm, and BC/AD.

Applicability

This variable applies only to the Oracle mode of OceanBase Database.

Permissions

Query variables
- Global scope
  
  Tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle mode) to query global system variables.
- Session scope
  
  Tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (in Oracle mode) to query session system variables.
Modify variables

Tenants cannot modify the values of global or session system variables in their own tenants.

Attribute

Attribute	Description
Type	Varchar
Default value	AMERICAN
Scope	GLOBAL SESSION
Modifiability	No, the variable cannot be modified.
Impact on plan generation	Yes