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

Cannot store dates / timestamps after 2038 in MariaDB/MySQL

    XMLWordPrintable

Details

    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

            is depended on by

            Task - A task that needs to be done. CAM-9636 Remove extra queries to prevent update of fields if respective column type is timestamp for MySQL and MariaDB

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed
            is duplicated by

            Bug Report - A problem which impairs or prevents the functions of the product. CAM-9379 Problems with jobs that have activationDate > 2037

            • L2 - Critical - Severe issues on production, test or development systems
            • Closed
            is related to

            Bug Report - A problem which impairs or prevents the functions of the product. CAM-9505 On MariaDB and MySQL an update operation leads to an update of date fields if column type is timestamp

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            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