how to format and display only the date from timestamp ?

how to format and display only the date from timestamp ?

currently it shows :-

Date : 19990827110223

i want it to show :- 27 / 08 / 1999

Thanks cause i appreciate your help.

Try this query:

SELECT DATE_FORMAT(columnName,'%d/%m/%Y') FROM tableName;

For othere date/time related functions take a look at the docs:
http://www.devshed.com/Server_Side/MySQL/Manual/manfiles/manual_Reference.html#Date_and_time_functions