nls_calendar

2025-11-14 07:33:33  Updated

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 sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle-compatible mode) to query the values of global system variables.

    • Session level

      Both the sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (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
  • Global
  • Session
Modifiability No, the variable is read-only.

Contact Us