Release Noteslink
June 2019link
Fivetran no longer supports invalid Date, Datetime and Timestamp values. For example, 2019-00-01 00:00:00 is invalid. This change immediately affects all new MySQL connectors, and we will roll it out gradually to existing connectors.
The supported ranges of Date, Datetime and Timestamp in MySQL are:
| Type | Supported Range |
|---|---|
| Date | '1000-01-01' to '9999-12-31' |
| Datetime | '1000-01-01 00:00:00' to '9999-12-31 23:59:59' |
| Timestamp | '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC |
We will load these invalid values as NULL into the destination and display a warning on your Fivetran dashboard. The warning will indicate the schemas, tables, and columns which contain NULL values.