What is MySQL's default DATE/DATETIME format?

From Navicat Wiki
Jump to: navigation, search

Apply OS : Windows, Mac, Linux, iOS

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.