Mysql datetime column extract error

asked 2019-01-17 03:28:54 -0500 gravatar image

updated 2019-01-17 10:04:50 -0500

I use the Mysql binlog to get data to target table,the source colun data is '2019-01-17 15:46:48',but the target table data is '2019-01-17 23:46:48',the source table and target table are in the same database,and are on the same mathine.

I just have another test yet.but I cannot upload the picture.

the source SQL to insert date to the source table is : insert into tta.test_1 values(5,456,666,'2019-01-17 23:43:13','咚锵锵'); the fourth column value is '2019-01-17 23:43:13'.

and in the preview(Mysql bin log and JDBC),the fourth column value is 'Jan 17, 2019 5:43:13 PM'.

then the target table ,the fourth column value is '2019-01-18 07:43:13'.

edit retag flag offensive close merge delete