select name, address, DATE(dateofbirth) from myfriends

select concat(dayofmonth(MyDateTime), month(MyDateTime), year(MyDateTime)) from MyTable;

SELECT DATE(col) AS col_date, TIME(col) AS col_time FROM table