date format

[Ika]

how do we echo a date format like 3 March 2002 ? the date in db is datetime type.

[jebster]

This could be totally off, but it works in my guest book so..

$datefromdb = $myrow['poster_time'];
$year = substr($datefromdb,0,4);
$mon  = substr($datefromdb,4,2);
$day  = substr($datefromdb,6,2);
$hour = substr($datefromdb,8,2);
$min  = substr($datefromdb,10,2);
$sec  = substr($datefromdb,12,2);
$post_time = date("l F dS, Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year));