Date field display

[cheese]

Hopefully an easy one....

How do I display a date / time field as a 'proper' date.

I am getting;

yyyy-mm-dd hh:mm:ss returned from the access database.

What I need is;

dd-mm-yyyy

I tried this, but it just returns a number;

$col3temp = odbc_result($row,4);
$col3 = substr($col3temp, 8, 2)+substr($col3temp, 5, 2)+substr($col3temp, 0, 4);

Would I need to turn $col3temp into a text field and, if so, how please.

Regards,

Neil.

[ucbones]

try

$dbdateexplode=explode(' ',$col3temp);
$date=$dbdateexplode[0];
$dateexplode=explode('-',$date);
echo $dateexplode[2]."-".$dateexplode[1]."-".$dateexplode[0];

Think that's right... sorry for any typos!

ucbones

[cheese]

Fantastic,

Thanks for that.

Neil.