Cannot store dates / timestamps after 2038 in MariaDB/MySQL

XMLWordPrintable

      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:

        This is the controller panel for Smart Panels app

              Assignee:
              Thorben Lindhauer
              Reporter:
              Philipp Ossler
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: