Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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")) ;
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")) ;