Answers for "date format dd mm yyy mysql"

convert dd/mm/yyyy to yyyy-mm-dd in mysql php

$var = '20/04/2012';
$date = str_replace('/', '-', $var);
echo date('Y-m-d', strtotime($date));

year format in date mysql

cur.execute('''SELECT id,home,visitor,finalscorehome,finalscorevisitor,eldatetime FROM games where Month(eldatetime) = Month(%s) AND YEAR(eldatetime) = Year(%s) AND DAY(eldatetime) = DAY(%s)''',(gamedate.date(),gamedate.date(),gamedate.date()))