What is MySQL's default DATE/DATETIME format?
Apply OS: Windows, Mac, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
MySQL's default DATE field format is YYYY-MM-DD. The supported range is 1000-01-01 to 9999-12-31.
DATETIME type is a date and time combination, and stores data in YYYY-MM-DD HH:MM:SS format. The allowed range is from 1000-01-01 00:00:00 to 9999-12-31 23:59:59.
*Supported/Allowed range means that although earlier values might work, there is no guarantee.