https://community.qlik.com/t5/Talend-Studio/Date-load-from-CSV-into-MySQL-from-30-03-2020-is-loading-1-day/m-p/2256731#M39031 <P>I've been loading files from CSV to MySQL using Talend and using date format of "yyyy-MM-dd".<BR />I've found a problem on dates from 30/03/2020 onwards where they are loading 1 day less than the data file, i.e. 30/03/2020 would load as 29/03/2020 or 01/04/2020 would load as 30/03/2020.<BR />Anything Prior to 30/03/2020 is loading absolutely fine.</P> Sat, 16 Nov 2024 02:25:49 GMT Anonymous 2024-11-16T02:25:49Z https://community.qlik.com/t5/Talend-Studio/Date-load-from-CSV-into-MySQL-from-30-03-2020-is-loading-1-day/m-p/2256731#M39031 <P>I've been loading files from CSV to MySQL using Talend and using date format of "yyyy-MM-dd".<BR />I've found a problem on dates from 30/03/2020 onwards where they are loading 1 day less than the data file, i.e. 30/03/2020 would load as 29/03/2020 or 01/04/2020 would load as 30/03/2020.<BR />Anything Prior to 30/03/2020 is loading absolutely fine.</P> Sat, 16 Nov 2024 02:25:49 GMT https://community.qlik.com/t5/Talend-Studio/Date-load-from-CSV-into-MySQL-from-30-03-2020-is-loading-1-day/m-p/2256731#M39031 Anonymous 2024-11-16T02:25:49Z