https://community.qlik.com/t5/Talend-Studio/MySQL-output-shifting-FirstOfMonth-to-End-of-Previous-Month/m-p/2368206#M131499 <P>OK, this is weird... I am calculating a firstOfMonth value that shows up properly in the last tLog before inserting into MySQL:</P> <P>&nbsp;</P> <P class="p1">2019-01-06</P> <P class="p1">2019-01-07</P> <P class="p1">2019-01-08</P> <P class="p1">2019-01-09</P> <P class="p1">&nbsp;</P> <P class="p1">But when I query the database, all 4 of those show up as:</P> <P class="p1">&nbsp;</P> <P class="p1">2019-05-31</P> <P class="p1">2019-06-30</P> <P class="p1">2019-07-31</P> <P class="p1">2019-08-31</P> <P class="p1">&nbsp;</P> <P class="p1">What the heck?</P> Thu, 13 Jun 2019 08:19:29 GMT fjblau 2019-06-13T08:19:29Z https://community.qlik.com/t5/Talend-Studio/MySQL-output-shifting-FirstOfMonth-to-End-of-Previous-Month/m-p/2368206#M131499 <P>OK, this is weird... I am calculating a firstOfMonth value that shows up properly in the last tLog before inserting into MySQL:</P> <P>&nbsp;</P> <P class="p1">2019-01-06</P> <P class="p1">2019-01-07</P> <P class="p1">2019-01-08</P> <P class="p1">2019-01-09</P> <P class="p1">&nbsp;</P> <P class="p1">But when I query the database, all 4 of those show up as:</P> <P class="p1">&nbsp;</P> <P class="p1">2019-05-31</P> <P class="p1">2019-06-30</P> <P class="p1">2019-07-31</P> <P class="p1">2019-08-31</P> <P class="p1">&nbsp;</P> <P class="p1">What the heck?</P> Thu, 13 Jun 2019 08:19:29 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-output-shifting-FirstOfMonth-to-End-of-Previous-Month/m-p/2368206#M131499 fjblau 2019-06-13T08:19:29Z https://community.qlik.com/t5/Talend-Studio/MySQL-output-shifting-FirstOfMonth-to-End-of-Previous-Month/m-p/2368207#M131500 <P>This may be due to the default timezone used by MySQL.</P><P>This link may help you&nbsp;<A href="https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql" target="_blank" rel="nofollow noopener noreferrer">https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql</A></P> Thu, 13 Jun 2019 11:08:17 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-output-shifting-FirstOfMonth-to-End-of-Previous-Month/m-p/2368207#M131500 TRF 2019-06-13T11:08:17Z