How to set data grid to display timezone region 'DD-MON-RR HH.MI.SSXFF AM TZR' format (4303628)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to set data grid to display timezone region 'DD-MON-RR HH.MI.SSXFF AM TZR' format
Description

nls_timestamp_tz_format is set to 'DD-MON-RR HH.MI.SSXFF AM TZR'

Run the following query:

select job_name,start_date from user_scheduler_jobs;

SQL*Plus displays MYJOB1 21-MAR-14 09.41.14.518658 AM CANADA/PACIFIC

Toad displays MYJOB1 03-21-2014 09:41:14.518658 -07:00

How can this be set in Toad?
Cause

View | Toad Options | Data Grids | Display | Time Format does not allow this option
Resolution

WORKAROUND

none

STATUS

An enhancement request has been submitted to the Toad Idea Pond. Please go here to vote or comment on the ER.
Defect ID

IP

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title