cur.execute("INSERT INTO tbl VALUES (?), [str(date[i])])

INSERT INTO tbl VALUES (2012-06-10);

INSERT INTO tbl VALUES (1996);

INSERT INTO tbl VALUES ('2012-06-10');