//Convert MM/DD/YYYY to YYYY-MM-DD. This format is useful if you want to insert into a MySQL date field.
|
1 2 3 4 5 6 7 8 9 |
function date_to_mysql_date($date){ $date_year=substr($date,6,4); $date_month=substr($date,0,2); $date_day=substr($date,3,2); $date=date("Y-m-d", mktime(0,0,0,$date_month,$date_day,$date_year)); return $date; } |
Incoming search terms:
- date format conversion in magento from dd/mm/yyyy to yyyy-mm-dd
