import Oracle date to Mysql

[YCHEN1629775312]

I want input the Oracle data and output to Mysql

The raw data is

the figure shown as below.

​

​

​

But when I check the output data , column 'sales_date' was changed (all date back one day).

BTIME also date type , but it is not changed.

WHY COLUMN SALES_DATE WILL CHANGE?

[Anonymous · Accepted solution]

Hi

This might be caused by different timezone in different server, so please go to check the timezone of Oracle and Mysql.

Regards

Shong

[YCHEN1629775312]

@Shicong Hong​ 

the process can work!

thank you