PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized 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/doc/refman/8.0/en/mysql-nutshell.html
Such implicit casts are now performed between temporal types (DATE, DATETIME, TIMESTAMP, TIME) and numeric types (SMALLINT, TINYINT, MEDIUMINT, INT/INTEGER, BIGINT; DECIMAL/NUMERIC; FLOAT, DOUBLE, REAL; BIT) whenever they are compared using any of ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--start-datetime=datetime Command-Line Format --start-datetime=datetime Type 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 ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
MySQL also recognizes the ODBC syntax corresponding to the standard SQL syntax: { d 'str' } { t 'str' } { ts 'str' } MySQL uses the type keywords and the ODBC constructions to produce DATE, TIME, and DATETIME values, respectively, including a ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee. MySQL ...A value of 0 signifies that there is no fractional ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
Use the --start-datetime and --stop-datetime options to specify a short time period around tp, and then look for the event in the output. Note Only use the --start-datetime and --stop-datetime options to help you find the actual event positions of ... The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...