Oracle CDC and DB timezone

asked 2019-04-30 04:31:18 -0500

Anuradha gravatar image

Hi team, We have SDC v3.8.1 & I am using CDC to extract data using online catalog. The oracle DB (12c) has following settings:

select dbtimezone from dual ; -- -06:00

select sysdate from dual; --4/30/2019 10:19:50 AM

The sysdate return in Dublin time but the server tz is -6:00 (US central) When CDC invokes the start logminer, what time does it apply?

Also, how does the CDC behave when time changes during day light saving? Will the start date offset get modified as per the day light saving timings?

edit retag flag offensive close merge delete