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.
Privilege requirements
Query variables
Global scope
Tenants of the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) to view the values of global system variables.Session scope
Tenants of the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle mode) to view the values of session system variables.
Modify variables
Tenants of the
systenant and all user tenants cannot modify the values of global or session system variables of their own.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | AMERICAN |
| Effective scope |
|
| Modifiability | No, this variable cannot be modified. |
| Impact on plan generation | Yes |