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 VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) to query global system variables.Session scope
Tenants can use the
SHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (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 |
|
| Modifiability | No, the variable cannot be modified. |
| Impact on plan generation | Yes |