https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374232#M136860 <P>@Shicong Hong​&nbsp;</P><P>the process can work!</P><P>thank you</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000KEOTyAAP.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147203iD02F4E33D99D396D/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000KEOTyAAP.png" alt="0695b00000KEOTyAAP.png" /></span>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 05 Nov 2021 08:27:53 GMT YCHEN1629775312 2021-11-05T08:27:53Z https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374230#M136858 <P>I want input the Oracle data and output to Mysql</P><P>​</P><P></P><P>The raw data is </P>the figure shown as below.<P>​<span class="lia-inline-image-display-wrapper" image-alt="0695b00000KELdvAAH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151874iFCD60A1EA343170A/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000KELdvAAH.png" alt="0695b00000KELdvAAH.png" /></span></P><P>​</P><P>​<span class="lia-inline-image-display-wrapper" image-alt="0695b00000KELhdAAH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148279i39A24DB10DEDC1B1/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000KELhdAAH.png" alt="0695b00000KELhdAAH.png" /></span></P><P>​<span class="lia-inline-image-display-wrapper" image-alt="0695b00000KELhsAAH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142516i88F38FDC207D2DF3/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000KELhsAAH.png" alt="0695b00000KELhsAAH.png" /></span></P><P>​</P><P>But when I check the output data , column 'sales_date' was changed (all date back one day).</P><P>BTIME also date type , but it is not changed.</P><P><B>WHY COLUMN SALES_DATE WILL CHANGE?</B></P><P>​</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000KELjPAAX.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133085i651EDC5252BF5F38/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000KELjPAAX.png" alt="0695b00000KELjPAAX.png" /></span></P><P></P><P></P><P></P><P></P><P>​</P> Fri, 15 Nov 2024 23:33:02 GMT https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374230#M136858 YCHEN1629775312 2024-11-15T23:33:02Z https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374231#M136859 <P>Hi </P><P>This might be caused by different timezone in different server, so please go to check the timezone of Oracle and Mysql.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Fri, 05 Nov 2021 05:04:56 GMT https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374231#M136859 Anonymous 2021-11-05T05:04:56Z https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374232#M136860 <P>@Shicong Hong​&nbsp;</P><P>the process can work!</P><P>thank you</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000KEOTyAAP.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147203iD02F4E33D99D396D/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000KEOTyAAP.png" alt="0695b00000KEOTyAAP.png" /></span>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 05 Nov 2021 08:27:53 GMT https://community.qlik.com/t5/Talend-Studio/import-Oracle-date-to-Mysql/m-p/2374232#M136860 YCHEN1629775312 2021-11-05T08:27:53Z