nls_timestamp_tz_format

Description

nls_timestamp_tz_format specifies the format for converting a TIMESTAMP WITH TIME ZONE value to a string and for implicitly converting a string to a TIMESTAMP WITH TIME ZONE value.

Privilege requirements

• Query variables

  • Global level

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

  • Session level

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

• Modify variables

  • Global level

    • sys tenants can directly modify the value of a global system variable.

    • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of a global system variable.

  • Session level

    sys tenants and all user tenants can directly modify the value of a session system variable.

Attributes

Usage

This variable specifies the default time zone format for the to_CHAR and to_timestamp_TZ functions. The commonly used value is YYYY-MM-DD HH24:MI:SS.FF TZR TZD.

Examples

• Session level

  obclient> SET nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FF TZR TZD';
  

• Global level

  obclient> SET GLOBAL nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FF TZR TZD';
  

References

• to_CHAR
• to_TIMESTAMP
• Date and time expressions
• Considerations for data conversion