Convert US date format to ANSI SQL date format (YYYY-mm-dd)

Question

I want to convert user-submitted date format (mm/dd/yyyy) to a MySQL date format (YYYY-mm-dd). Submission is via a simple PHP form direc tto MySQL database.

Answer 1

$mysql_date = date('Y-m-d H:i:s', strtotime($user_date));