Date 20191006 changed to 20191005 when uploaded to Snowflake

[Anonymous]

Hi, something very weird is happening when I'm uploading a CSV with dates to Snowflake. All dates are uploaded fine except for 20191006 which is transformed to 20191005. I'm using a very simple transformation "TalendDate.parseDate("yyyy-MM-dd",row1.newColumn)"

I tried hardcoding and only adding a column "TalendDate.parseDate("yyyy-MM-dd","2019-10-06")" and it has the same behaviour of transforming it to 20191005 when instead of uploading to Snowflake I output a CSV it works fine. When uploading the CSV to Snowflake (without using Talend) it also works fine.

[Anonymous · Accepted solution]

I found the solution... a tJava component needs to be added before the outut to Snowflake with the following code:
java.util.TimeZone.setDefault(java.util.TimeZone.getTimeZone("GMT")) ;