I m reading the data from Snowflake database and there is a date type in timestamp z (9) and when I tried to insert the data in MySQL is giving me the error Date/time string
Snowfleke Data
Mysql Data Strcuture
Question
Date Format from snowflake
+66
Not sure what your question is, but I guess you need to reformat you dates to make them fit in MYSQL? You can do this using the DateTimeConverter. Without sample data from both systems it is hard to explain more than this.
+66i tried but i m not succes with DateTimeConverter ....
Post a sample date you get from Snowflake and a sample date as you need to send to MYSQL?
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.