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
Userlevel 6
+32
- Celebrity
- 2332 replies
-
5 October 2022
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.
+5
i tried but i m not succes with DateTimeConverter ....
Userlevel 6
+32
- Celebrity
- 2332 replies
-
5 October 2022
i 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?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.