Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date load from CSV into MySQL from 30/03/2020 is loading 1 day less than in the dataf ile.

I've been loading files from CSV to MySQL using Talend and using date format of "yyyy-MM-dd".
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.
Anything Prior to 30/03/2020 is loading absolutely fine.

Labels (4)
0 Replies