Skip to main content

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

 

imageSnowfleke Data

image 

Mysql Data Strcuture

image

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.


i tried but i m not succes with DateTimeConverter ....


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