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.