https://dev.mysql.com/sys-sys-config.html
set_time The timestamp of the most recent modification to the row. This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The ...
https://dev.mysql.com/thread-information.html
The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. When you are attempting to ascertain what your MySQL server is doing, it can be helpful to examine the process list, ...
https://dev.mysql.com/triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The ...
https://dev.mysql.com/two-digit-years.html
For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates specified with ambiguous year values using these rules: Year values in the range 00-69 are converted to 2000-2069. Date values with 2-digit years are ambiguous because the century is ...
https://dev.mysql.com/upgrade-prerequisites.html
In-place upgrade to MySQL 8.0 is not supported if tables contain old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). Before upgrading to the latest MySQL 8.0 release, ...
https://dev.mysql.com/upgrading-from-previous-series.html
Removal of MAXDB means that the TIMESTAMP data type for CREATE TABLE or ALTER TABLE is no longer treated as DATETIME. Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL ...
https://dev.mysql.com/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...
