how to show DATE TIME from db table as dd/mm/yyyy

[lands]

when showing date and time from a table it shows it as yyyy/mm/dd is it possible to change it to dd/mm/yyyy or yy and same for the time

[Derokorian]

$date = "2011/07/26";
echo date('j/n/y',strtotime($date));

Look at date() to see all the formatting options you have.

[leatherback]

check the mysql manual for http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format

select DATE_FORMAT(DATEFIELD, '%d/%m/%Y') as date ...