{"id":4029,"date":"2015-11-03T19:49:17","date_gmt":"2015-11-04T03:49:17","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=4029"},"modified":"2023-12-27T02:21:33","modified_gmt":"2023-12-27T09:21:33","slug":"mysql-date","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-date\/","title":{"rendered":"MySQL DATE Data Type"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, we will introduce you to the MySQL DATE<\/code> data type and show you some useful date functions to handle the date data effectively.<\/p>\n\n\n\n

Introduction to MySQL DATE data type<\/h2>\n\n\n\n

MySQL DATE<\/code> is one of the five temporal data types<\/a> used for managing date values. MySQL uses yyyy-mm-dd<\/code>\u00a0format for storing a date value. This format is fixed and it is not possible to change it.<\/p>\n\n\n\n

For example, you may prefer to use mm-dd-yyyy<\/code> format but you can’t. Instead, you follow the standard date format and use the DATE_FORMAT<\/a><\/code> function to format the date the way you want.<\/p>\n\n\n\n

MySQL uses three bytes to store a DATE<\/code> value. The DATE<\/code> values range from\u00a01000-01-01<\/code>\u00a0to\u00a09999-12-31<\/code>.<\/p>\n\n\n\n

If you want to store a date value that is out of this range, you need to use a non-temporal data type like an integer<\/a> e.g., three columns, and each column for the year, month, and day. <\/p>\n\n\n\n

Also, you need to create stored functions<\/a> to simulate the built-in date functions<\/a> provided by MySQL, which is not recommended.<\/p>\n\n\n\n

MySQL Date values with two-digit years<\/h2>\n\n\n\n

MySQL stores the year of the date value using four digits. In case you use two-digit year values, MySQL still accepts them with the following rules:<\/p>\n\n\n\n