How to convert php date into mysql format Nikunj K 11 years ago 1. MySQL column datatype is “DATE” $date = date(‘Y-m-d’, strtotime(str_replace(‘-‘, ‘/’, $date))); 2. MySQL column datatype is “DATETIME”: $date = date(‘Y-m-d H:i:s’, strtotime(str_replace(‘-‘, ‘/’, $date))); Share your Love