PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be specified. Functions that expect date values usually accept datetime values and ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...For example, in contexts where MySQL expects a date, it interprets any of '2015-07-21', '20150721', and 20150721 as 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 ...For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. The TIMESTAMP and DATETIME types have special automatic updating behavior, described in Section 13.2.5, “Automatic Initialization and ...
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, ...Conversion of DATE values: Conversion to a DATETIME or TIMESTAMP value adds a time part of '00:00:00' because the DATE value contains no time ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
From an InnoDB perspective, the performance considerations of such operations involve the time that the data dictionary is locked to ensure that interrelated objects are all updated, and the time to update memory structures such as the buffer pool.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
avoid_temporal_upgrade Command-Line Format --avoid-temporal-upgrade[={OFF|ON}] Deprecated Yes System Variable avoid_temporal_upgrade Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF This variable controls whether ALTER ...Most of them can be changed dynamically at runtime using the SET statement, which enables you to modify operation of the server without having to stop and restart ...
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 ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...Features Added in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
There are many parameters which control buffer sizes, pool sizes, timeouts, and so forth. It is read only when the cluster is started for the first time, and cannot be used to reassign a data node to a different node group online. You are not ...The ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...MySQL can also convert a ...