Date/Time Formating

[sgtpepper]

Hi,

In mysql database I have a timestamp like this

20030926164253

How can I convert this to an actual date in php?

[maxpup979]

this is probably not the best way to do it...but it does work--
function convert_time($in){
$year=substr($in, 0, 4);
$month=substr($in,4,2);
$day=substr($in,6,2);
$hour=substr($in,8,2);
$second=substr($in,10,2);
$ms=substr($in,12,2);
$hr=$month."-".$day."-".$year." ".$hour.":".$second.":".$ms;
return $hr;
print $year;
}
$temp=convert_time("20030926164253");
print $temp;

and btw--its oompa loompa--and yes, they have sex...don't ask how I know

[drawmack]

http://www.php.net/strtotime
http://www.php.net/date