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

Cannot store dates / timestamps after 2038 in MariaDB/MySQL

    XMLWordPrintable

Details

    • Bug Report
    • Status: Closed
    • L3 - Default
    • Resolution: Fixed
    • 7.9.0
    • 7.11.0, 7.11.0-alpha1
    • engine

    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:

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce