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/year.html
The YEAR type is a 1-byte type used to represent year values. It can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display width. Note As of MySQL 8.0.19, the YEAR(4) data type with ...As 1- or 2-digit strings in the range '0' to ...
https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html
Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
To also determine the total profit summed over all years, you must add up the individual values yourself or run an additional query. Following each set of rows for a given year, an extra super-aggregate summary row appears showing the total for all ... The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
For example: mysql> SELECT DATE_ADD('2006-05-00',INTERVAL 1 DAY); -> NULL mysql> SELECT DAYNAME('2006-05-00'); -> NULL Several functions are strict when passed a DATE() function value as their argument and reject incomplete dates with a day part of ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
These rules govern conversion to YEAR: For a four-digit number in the range 1901-2155 inclusive, or for a string which can be interpreted as a four-digit number in this range, return the corresponding YEAR value. For a number consisting of one or ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
clauses, so that s0 contains only those records for which YEAR(dob) is less than 1960 and s1 contains those rows in which YEAR(dob) is greater than or equal to 1960 but less than 1970. For example, partitions p1 and p2 together cover the years 1980 ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
The TIMESTAMP syntax produces a DATETIME value in MySQL because DATETIME has a range that more closely corresponds to the standard SQL TIMESTAMP type, which has a year range from 0001 to 9999. (The MySQL TIMESTAMP year range is 1970 to 2038.) String ... 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 ...
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. MySQL displays YEAR values in YYYY format, but permits assignment of values to YEAR columns using either strings or numbers. For additional ...For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
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. Although MySQL tries to interpret values in several formats, date parts must always be given in year-month-day order (for example, ...Each ...