sql = """CREATE TABLE TEST_TABLE
        ("ID" TEXT,
        "DATE_IN" DATE,
        "WEEK_IN" number)
    """
cursor.execute(sql)
sql = 'INSERT INTO TEST_TABLE(ID, DATE_IN, WEEK_IN) VALUES (?,?,?)'
cursor.executemany(sql, [[1, '2012-03-25', 13], [2, '2013-03-25', 13]])
sql = 'SELECT ID FROM TEST_TABLE where WEEK_IN = 13 and DATE_IN > ?'
cursor.execute(sql, [this_year])
for row in cursor:
    pass
Запрос Python SQLITE3 SELECT с вычисленной строкой даты и времени не работает