GIYF:
MySQL :: MySQL 8.0 Reference Manual :: 11.3 Date and Time Types[
^]
If you insist on "dd-mm-yyyy' format, which may be ambiguous if your users expect "mm-dd-yyyy', you may have to google some more to see how to format dates appropriately. I'd suggest you stick with "yyyy-mm-dd", its unambiguous, and as a bonus, if you need (or want) to sort by date in the app, as opposed to retrieving sorted data from the database, a straight string compare works correctly, without having to write a method to decompose and compare the dates.