The simplest way would be to use a custom function:
Paste this code at the top (or bottom of your page)
<?php
/*
Format MySQL Date Field to DD-MM-YYYY
----------------------------------------------------------
*/
function i8_formatMySQLDate($date) {
$d = str_replace(" ","",$date);
$d = explode('-', $date);
$d = $d[2].'-'.$d[1].'-'.$d[0];
return $d;
}
?>
You would then call the function like so:
<?php echo i8_formatMySQLDate($row_RecordSetName['datefield']); ?>