https://dev.mysql.com/date-and-time-types.html
The date and time types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For temporal types that include a date part (DATE, DATETIME, and TIMESTAMP), use of these values may produce warning or errors. Data Type ...
https://dev.mysql.com/host-cache-table.html
FIRST_SEEN The timestamp of the first connection attempt seen from the client in the IP column. LAST_SEEN The timestamp of the most recent connection attempt seen from the client in the IP column. FIRST_ERROR_SEEN The timestamp of the first error ...
https://dev.mysql.com/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/mysqld-safe.html
--mysqld-safe-log-timestamps This option controls the format for timestamps in log output produced by mysqld_safe. UTC, utc ISO 8601 UTC format (same as --log_timestamps=UTC for the server). SYSTEM, system ISO 8601 local time format (same as ...
https://dev.mysql.com/persisted-system-variables.html
The MySQL server maintains system variables that configure its operation. A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. Many system variables are ...
https://dev.mysql.com/replication-options-reference.html
The following two lists provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. The command-line options and system variables in the following list relate to replication ...
https://dev.mysql.com/added-deprecated-removed.html
binlog_transaction_dependency_tracking: Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by slave's multithreaded applier.. original_commit_timestamp: ... This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/c-api-data-structures.html
(The BLOB_FLAG and TIMESTAMP_FLAG flags are unneeded.) ENUM and SET values are returned as strings. This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream ...
https://dev.mysql.com/c-api-prepared-statement-data-structures.html
MYSQL_TIME This structure is used to send and receive DATE, TIME, DATETIME, and TIMESTAMP data directly to and from the server. Set the buffer member to point to a MYSQL_TIME structure, and set the buffer_type member of a MYSQL_BIND structure to one ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/c-api-prepared-statement-date-handling.html
The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME structure. For DATE, TIME, DATETIME, or TIMESTAMP values, set buffer_type to MYSQL_TYPE_DATE, ...The members of this structure are described in Section 28.7.9, “C API Prepared Statement Data ...
