nls_timestamp_tz_format

Description

nls_timestamp_tz_format specifies the format for converting a timestamp with time zone (TIMESTAMP TZ) to a string and for implicitly converting a string to a TIMESTAMP TZ.

Privilege requirements

• Query variables

  • Global level

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

  • Session level

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

• Modify variables

  • Global level

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

    • Oracle user tenants can modify the value of a global system variable only if they have the ALTER SYSTEM privilege.

  • Session level

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

Attributes

Usage

This variable specifies the default time zone format for timestamps used with the to_CHAR and to_timestamp_TZ functions. The most 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