如何在SQLite数据库中插入日期

CREATE TABLE my_table (
    id INTEGER PRIMARY KEY,
    date DATE
);

INSERT INTO my_table (date) VALUES (?);

import sqlite3
import datetime

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

# 准备要插入的日期数据
date = datetime.date.today()

# 构建插入语句
insert_query = "INSERT INTO my_table (date) VALUES (?)"

# 执行插入语句
cursor.execute(insert_query, (date,))

# 提交事务
conn.commit()

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