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.

Oracle Mode
-----------

MariaDB starting with 10.3
--------------------------
In Oracle mode from MariaDB 10.3, DATE with a time portion is a synonym for
DATETIME. See also mariadb_schema.

Examples
--------

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 |
+------------+

URL: https://mariadb.com/kb/en/date/https://mariadb.com/kb/en/date/