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

Provide option for exporting DATETIME columns as a String

    XMLWordPrintable

Details

    Description

      DATETIME columns don't contain TZ information and as such don't represent an exact point on the timeline but rather a logical date and time, such as "2018-01-13 09:48:27". Hence it's questionable to represent such columns as epoch millis, as this requires a time zone for mapping the logical date to such exact point on the time line.

      Currently, UTC is used for this, but this is a rather arbitrary decision and not really transparent to downstream consumers. Therefore, a new mapping mode should be provided, which exports DATETIME columns as strings, keeping their nature of being logical dates and not exact points on the timeline.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              gmorling@redhat.com Gunnar Morling
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: