jwills / target-duckdb

A Singer.io target for DuckDB
Other
17 stars 12 forks source link

ERROR : On Converting timestamp column with value 0000-00-00 00:00:00 #45

Open g-diwakar opened 3 months ago

g-diwakar commented 3 months ago

Describe the bug It is throwing an error on converting the source column with timestamp data type having value 0000-00-00 00:00:00.

To Reproduce Steps to reproduce the behavior: Create a mysql table with one column having timestamp datatype. Set the value 0000-00-00 00:00:00. Run the pipeline

Screenshots image