Start a new topic

Display Actual Timezone Stored in Oracle

Oracle has a data type, TIMESTAMP(6) with TIME ZONE.  That means for such a column every record could have a separate time zone stored in Oracle.

How I get DBViz to display in the query results the exact time zone that is stored in the Database (versus translating each value to the time zone set in the settings under Data Formats > Time Zone)?

I have the DbViz Time Zone set to UTC.  I ran the following query to update a record, giving it a particular time zone:

   update document_demographics 

   set date_of_birth = TIMESTAMP '2017-08-09 07:00:00 -7:00'   

   where document_demographics_pkid = 50

I pasted below what I see in the results.  The first one uses the "z" format character, whereas the other uses "Z".  

        2017-08-09 07:00:00 +0000

        2017-08-09 07:00:00 UTC

It seems DbViz is manipulating the time for display so that it can show results based on the Time Zone setting.  Unfortunately, it gives me no view into what is actually stored in the DB (which is the point of a query tool).  Is there a setting I can change to see what's actually stored for time zone?

1 Comment


We will look into this and get back to you.



Login or Signup to post a comment