in mysql a date is like '2005-01-20' http://dev.mysql.com/doc/mysql/en/DATETIME.html
for outputting in your dd-mm-yyyy you could use DATE_FORMAT()
http://dev.mysql.com/doc/mysql/en/Date_ ... tions.html
Question about ordering
Moderator: General Moderators