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
+54
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.
+54asadamjad wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.