here you go...
//display datetime from mysql format
function mysql_timestamp_to_time($dates)
{
return mktime( intval(substr($dates,8,2)), intval(substr($dates,10,2)) , intval(substr($dates,12,2)), intval(substr($dates,4,2)), intval(substr($dates,6,2)), intval(substr($dates,0,4)) );
}
//and back
function time_to_mysql_timestamp($ts)
{
$d=getdate($ts);
$yr=$d["year"];
$mo=$d["mon"];
$da=$d["mday"];
$hr=$d["hours"];
$mi=$d["minutes"];
$se=$d["seconds"];
return sprintf("%04d%02d%02d%02d%02d%02d",$yr,$mo,$da,$hr,$mi,$se);
}