Hi. The database does not store your date in that format. Your query tool shows it like that, but internally, the date is stored as a numeric value.
You can use the
MySQL date formatting functions to show the date as you please.
In a
java program, you could format the date using
java.text.SimpleDateFormat. To convert your dd-mm-yyyy from
String to Date, you can use SimpleDateFormat.parse(). You can then insert that Date in your database.
Here is an example of both cases.
Regards, Jan