JDBC Query consumer converting time zone, but time value remains as is

asked 2020-05-20 02:59:04 -0500

Iqbal gravatar image

updated 2020-05-20 23:58:37 -0500

Hi, I have a JDBC query consumer to retrieve data from Oracle database. When it is pulling date fields, the time zone is only converted to SDC time zone leaving the time as it is.

Oracle DB is in UTC +00:00 . SDC converts it to EST/EDT

Example:

source date: 26-JAN-12 06.46.11.000000000 AM

SS conversion : Jan 26, 2012 6:46:11 AM [EST5EDT EDT] (or) 2012-01-26 06:46:11.000 -0500

Where it should have been : Jan 26, 2012 1:46:11 AM [EST5EDT EDT] (or) 2012-01-26 01:46:11.000 -0500

I also tried setting up the database session time zone in the Init query like "alter session set time_zone='+00:00'" and "alter session set time_zone='dbtimezone'". But no use.

Note: Oracle CDC client is converting the time and time zone correctly.

Please let me know the solution for this. Thanks, Iqbal.

edit retag flag offensive close merge delete