A date. The supported range is '
1000-01-01' to '
DATE values in '
YYYY-MM-DD' format, but can be assigned dates in looser formats, including strings or numbers, as long as they make sense. These include a short year,
YY-MM-DD, no delimiters,
YYMMDD, or any other acceptable delimiter, for example
YYYY/MM/DD. For details, see date and time literals.
0000-00-00' is a permitted special value (zero-date), unless the NO_ZERO_DATE SQL_MODE is used. Also, individual components of a date can be set to 0 (for example: '
2015-00-12'), unless the NO_ZERO_IN_DATE SQL_MODE is used. In many cases, the result of en expression involving a zero-date, or a date with zero-parts, is
NULL. If the ALLOW_INVALID_DATES SQL_MODE is enabled, if the day part is in the range between 1 and 31, the date does not produce any error, even for months that have less than 31 days.
MariaDB starting with 10.3
CREATE TABLE t1 (d DATE); INSERT INTO t1 VALUES ("2010-01-12"), ("2011-2-28"), ('120314'),('13*04*21'); SELECT * FROM t1; +------------+ | d | +------------+ | 2010-01-12 | | 2011-02-28 | | 2012-03-14 | | 2013-04-21 | +------------+
- mariadb_schema data type qualifier