Extract always shows UTC/GMT timestamp in SHOWTRANS output (Doc ID 2732205.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Extract always shows UTC/GMT timestamp in SHOWTRANS output.

i.e. extract (both classic & integrated extracts) display timestamp in SHOWTRANS output always in UTC.

SQL> select scn_to_timestamp(13922959159) as timestamp from dual;

TIMESTAMP
---------------------------------------------------------------------------
06-JUL-20 09.29.48.000000000 AM <= PDT

SQL> select dbtimezone from dual;

DBTIME
------
-07:00

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
---------------------------------------------------------------------------
-07:00
+++++

GGSCI (<HOST_NAME> 8> send EADR2PRD showtrans

Sending SHOWTRANS request to EXTRACT EADR2PRD ...

------------------------------------------------------------
XID: 0.57.33.1469812
Items: 0
Extract: EADR2PRD
Redo Thread: 1
Start Time: 2020-07-06T16:29:49.000Z <= UTC
SCN: 3.1038057271 (13922959159)
Redo Seq: 99163
Redo RBA: 1131793424
Status: Running
++++++

Changes

 N/A

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.