depending on the language used as the front end to the mysql back end,
php $date=strtotime('string');
asp $date=DateTime.Parse('string');
in sql getdate($date)

don't use those codes look em...

Glad it all helped, examples stick in my mind better too

good catch, stared at it and didnt see