$row["burned"] = 2006-10-13 00:00:00 $row["burned_year"] = substr($row["burned"], 0, 4); $row["burned_month"] = substr($row["burned"], 5, 7); $row["burned_day"] = substr($row["burned"], 8, 10); $row["burned_year"] = 2006 $row["burned_month"] = 10-13 0 $row["burned_day"] = 13 00:00:0