Best way to convert dates for MySQL

[rtcary]

Is there a better way to convert a date in the mm/dd/yyyy format to that used by MySQL than what I am doing?

/ Convert a date for MySQL /
function mysql_convert_date($date) {
if ($date) {
$array = explode("/", $date);
if (checkdate($array[0], $array[1], $array[2])) {
$time = mktime(0, 0, 0, $array[0], $array[1], $array[2]);
$date = date("Y-m-d", $time);
} else {
$date = "";
}
} else {
$date = "";
}
return $date;
}

Todd

[bradgrafelman]

Yup: use YYYY-mm-dd format to start out with. :p

Where is the date coming from?

[rtcary]

The date is coming from user input where it is validated with

/ Is date proper /
function is_date($date) {
if ($date) {
$array = explode("/", $date);
if (count($array) != 3) {
return 0;
} else {
if (checkdate((int)$array[0], (int)$array[1], (int)$array[2])) {
return 1;
} else {
return 0;
}
}
} else {
return 0;
}
}

The reason I asked the question is that often I find that I am re-inventing the wheel because there is either a built in function or someone with better skills has made the function compact.

Thanks...

Todd

[bradgrafelman]

A better way to do it is to have the data input in the format that you want it to be in. For example, rather than a textbox asking for a date, use dropdown boxes for month, day, and year, then combine the values together to form your date.