Note
The variable was introduced in V2.2.77.
Description
The nls_calendar variable controls the calendar system used by the database.
Applicability
The variable applies only to OceanBase Database's Oracle-compatible mode.
Privilege requirements
Query variables
Global level
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle-compatible mode) to query the values of global system variables.Session level
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle-compatible mode) to query the values of session system variables.
Modify variables
The value of this variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | GREGORIAN |
| Effective scope |
|
| Modifiability | No, the variable is read-only. |