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
Neither the
systenant nor any user tenant can modify the values of global or session system variables for their own tenant.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | GREGORIAN |
| Effective scope |
|
| Modifiability | No, the variable cannot be modified. |