edit the table, to add a new column as a date,a nd store the timestamp, not any text representation.as php date() or mysql now()..
a text date is bigger, size matters in the opposite way
a timestamp is faster
a timestamp is easier to select date or time ranges "where date > number and date < number2"
the database is for computers, human readability is a liability, it causes errors, 10/7/11 can be 10 july 2011, 11 july 2010, 7 october 2011,
the information can be simply printed in human readble form on output, using something like cyberspatium's code sample
NOTE:not bagging prior poster;sample is accurate, even customizations to individual user regional preferences, based on this code, so that americans will see 10/7/09 and english will see 7/10/09 on the same day 7 October 2009;
it does not matter when there are ten records in the db, it begins to matter when there are ten thousand records in the db, timeout failures when there are ten million records in the db, unless you optimize the system at the start
anyhow, if you store a text date, how do you simply select between april 1 and august 15 at 3 pm last yeqar