Apply OS: Windows, macOS, 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.

Have more questions?
Submit Ticket