timestamp issue when read from mysql then write to snowflake

User118722

I am getting a database error when trying to write to a snowflake table: expecting timestamp_ntz(9) but got timestamp_ltz((9) for all the date fields that come out of mysql database, has anyone experienced the same issue and how did you solve it? Thanks!

MPB_

Hey ,

have you tried to add a convert function into your SELECT query?

https://w3resource.com/mysql/date-and-time-functions/mysql-convert_tz-function.php