Skip to main content
Question

Date Format from snowflake

  • October 4, 2022
  • 3 replies
  • 48 views

Forum|alt.badge.img+5

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

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2937 replies
  • October 5, 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.


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • October 5, 2022

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


nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2937 replies
  • October 5, 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?