Mysql And Datetime

I am using mysql as my database and which to use a datetime field, for both displaying the data and time and using it to sort the recordsets.

And although when you look at the Db it shows the data and time like this

yyyy-mm-dd hh:mm:ss

however if you simply display the field it displays like this

mm/dd/yyyy hh:mm:ss am (or pm)

I want to sort the data out so that it displays dd/mm/yyyy and there is no time, i can do this but wanted to know if there is a better way of doing it

My problems being I first have to work out if the date is below 10 then us a split function according, then the same with the month, then i have to use a massive if statement, to get it to display in words, and then I have to us the queries before so i can split the year, even if i use to fields in the db to store time and date i would still have the same problems, what is the best way to do this, Plus i may have more than one record to do, will this make a big different in processing my page if i say have 20 records to do.

and just to make sure is the timedate field suitable to sort my record sets out.