Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-9498

Cannot store dates / timestamps after 2038 in MariaDB/MySQL

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.9.0
    • Fix Version/s: 7.11.0, 7.11.0-alpha1
    • Component/s: engine
    • Labels:

      Description

      Currently, we use two different types to store a date value in a MariaDB/MySQL database: TIMESTAMP and DATETIME. The type TIMESTAMP has the limitation that it only works until 2038.

      AT:

      • replace the type TIMESTAMP to allow dates after 2038
      • use one type for all dates in the database

      References:

        Issue Links

          Activity

            People

            • Assignee:
              thorben.lindhauer Thorben Lindhauer
              Reporter:
              philipp.ossler Philipp Ossler
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development