Many settings allow you to get a better overview and bring more order to your MySQL software. Thanks to them, you can better sort your different tables and access them even faster if necessary. To this end, the database management system offers several different field types for dates and times. In addition to MySQL TIME, MySQL DATETIME and MySQL TIMESTAMP, the system offers the MySQL DATE command, which is as convenient as it is easy to use; it can also render you valuable services if you work with it daily.
The MySQL DATE command works with values that contain a date, but no time; it can extract and reproduce the date present in a declaration. Entries are always saved in the format « YYYY-MM-DD », with values ranging from « 1000-01-01 » to « 9999-12-31 ».