尝试让python sqlite与日期而不是实际的日期时间字段进行比较

import sqlite3
from datetime import datetime

# 连接到SQLite数据库
conn = sqlite3.connect('database.db')
cursor = conn.cursor()

# 创建一个表
cursor.execute('''CREATE TABLE IF NOT EXISTS events
                  (id INTEGER PRIMARY KEY AUTOINCREMENT,
                   event_date DATE,
                   event_name TEXT)''')

# 插入一些示例数据
cursor.execute("INSERT INTO events (event_date, event_name) VALUES (?, ?)",
               (datetime(2022, 1, 1).strftime('%Y-%m-%d'), 'New Year'))

cursor.execute("INSERT INTO events (event_date, event_name) VALUES (?, ?)",
               (datetime(2022, 12, 25).strftime('%Y-%m-%d'), 'Christmas'))

# 查询日期大于等于指定日期的事件
date_to_compare = datetime(2022, 6, 1).strftime('%Y-%m-%d')
cursor.execute("SELECT * FROM events WHERE event_date >= ?", (date_to_compare,))
rows = cursor.fetchall()

# 打印查询结果
for row in rows:
    print(row)

# 关闭数据库连接
conn.close()