-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
7.9.0
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
- is depended on by
-
CAM-9636 Remove extra queries to prevent update of fields if respective column type is timestamp for MySQL and MariaDB
- Closed
- is duplicated by
-
CAM-9379 Problems with jobs that have activationDate > 2037
- Closed
- is related to
-
CAM-9505 On MariaDB and MySQL an update operation leads to an update of date fields if column type is timestamp
- Closed