[RESOLVED] Insert Date into MySQL DB

[obrienkev]

Hi all,

How do I insert this date (01/12/2006) into a MYSQL date format field?

Thanks.

Kevin.

[obrienkev]

Well I came across this...and it works:

// process date
list($day, $month, $year) = split('[/.-]', $date1);
echo "Day: $day; Month: $month; Year: $year<br />\n";
$class_date = $year.'-'.$month.'-'.$day;
echo $class_date;