https://dev.mysql.com/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 9.1.3, “Date and Time Literals”. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/date-and-time-functions.html
Functions that expect date values usually accept datetime values and ignore the time part. Functions that expect time values usually accept datetime values and ignore the date part. In addition, UNIX_TIMESTAMP() assumes that its argument is a ...
https://dev.mysql.com/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...An auto-updated column is automatically updated to the current timestamp when the value of any other column in the row is changed from its current ...
https://dev.mysql.com/mysqlbinlog.html
--start-datetime=datetime Start reading the binary log at the first event having a timestamp equal to or later than the datetime argument. The datetime value is relative to the local time zone on the machine where you run mysqlbinlog. The value ...
https://dev.mysql.com/date-and-time-type-conversion.html
For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of values. This means that a date such as '1968-01-01', while valid as a DATE or DATETIME value, ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/date-and-time-type-overview.html
For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee. MySQL permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) ...For ...
https://dev.mysql.com/point-in-time-recovery-times.html
To indicate the start and end times for recovery, specify the --start-datetime and --stop-datetime options for mysqlbinlog, in DATETIME format. To restore the table and data, you could restore the previous night's backup, and then execute the ...on ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/date-and-time-literals.html
DATE 'str' TIME 'str' TIMESTAMP 'str' MySQL recognizes those constructions and also the corresponding ODBC syntax: { d 'str' } { t 'str' } { ts 'str' } MySQL uses the type keyword and these constructions produce DATE, TIME, and DATETIME values, ...
