Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-205

DATE datatype treated differently by MySQL Connector

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.5
    • 0.4.1
    • mysql-connector

      So we are inserting date as 11-04-03 in MySQL which in MySQL is treated as 2011-04-03 and by the dbz it is being treated as 0011-04-03 .

      MySQL doc for DATE datatype
      Few lines from docs:
      Dates containing two-digit year values are ambiguous because the century is unknown. MySQL interprets two-digit year values using these rules:

      Year values in the range 00-69 are converted to 2000-2069.

      Year values in the range 70-99 are converted to 1970-1999.

            rhauch Randall Hauch (Inactive)
            sanzzzay Sanjay Singh (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: