nls_date_language

Description

nls_date_language specifies the default language for date-related functions in the database. It is used in the TO_DATE and TO_CHAR functions to handle input or output of date, month, AM/PM, and BC/AD information.

Privilege requirements

• Query variables

  • Global level

    The sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) to view the value of a global system variable.

  • Session level

    The sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) to view the value of a session system variable.

• Modify variables

  This variable cannot be modified.

Attributes