Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Oracle CDC and DB timezone

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?