from datetime import datetime, date

sql = "SELECT name, dob FROM users"
result1 = cur.execute(sql).fetchall()

for row in result1:
    print row
    name, dob = row[1], row[2]
    print dob

    try:
        sql = "SELECT name FROM users WHERE dob = %s" % dob
        result2 = cur.execute(sql).fetchall()
        print result
    except:
        y, m, d = dob.year, dob.month, dob.day
        mydate  = date(y, m, d)

        sql = "SELECT name FROM users WHERE dob => %s" % dob
        result2 = cur.execute(sql).fetchall()
        print result

        sql = "SELECT name FROM users WHERE dob = %s" % dob
        result2 = cur.execute(sql).fetchall()
        print result

SELECT name FROM users WHERE DateValue(registered) <= '20-04-2015'

sql = "SELECT name FROM users WHERE dob = '%s'" % dob

sql = "SELECT name FROM users WHERE dob = %s" % dob