timestamp issue when read from mysql then write to snowflake
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!
Find more posts tagged with
Sort by:
1 - 1 of
11
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
Sort by:
1 - 1 of
11
Hey ,
, have you tried to add a convert function into your SELECT query?