From dd-mm-yyyy TO yyyy-mm-dd On INSERT

[Anonymous]

You could use it to specify the format:
DATE_FORMAT
http://www.phpfreaks.com/mysqlref/3.php

 

[Anonymous]

Well,
you can't format the input of the DATE column type
but you could format the output using

DATE_FORMAT(date,format)

Also, as you suggested you can save it in the database as varchar and then give it the format.

bye!