date format convert

[kenny873]

I have a date format as 20030401 --> YYYYMMDD

how can I convert it into 2003 April 01?

[planetsim]

date("Y F d",$time);

$time being the time as in 20030401

[kenny873]

Originally posted by planetsim
date("Y F d",$time);
<? $time = 20030401;
date("Y F d",$time);
?>
$time being the time as in 20030401

[xblue]

date takes a unix timestamp as argument, so what planetsim suggested would probably not work the way you wanted it.

if that YYYYMMDD timestamp is coming from mysql, I'd recommend formatting it right when selecting records.

SELECT DATE_FORMAT(date_column, '%Y %M %d') AS fdate ...