通过SQLite3在python中编辑日期和时间

import sqlite3
from datetime import datetime

# 连接到 SQLite 数据库（如果不存在则创建）
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建一个包含日期时间字段的表
cursor.execute('''
CREATE TABLE IF NOT EXISTS events (
    id INTEGER PRIMARY KEY,
    name TEXT,
    event_date TEXT
)
''')

# 插入一条包含日期时间的记录
event_date = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
cursor.execute("INSERT INTO events (name, event_date) VALUES (?, ?)", ('Meeting', event_date))
conn.commit()

# 查询并打印所有记录
cursor.execute("SELECT * FROM events")
rows = cursor.fetchall()
for row in rows:
    print(row)

# 更新一条记录的日期时间
new_event_date = (datetime.now() + timedelta(days=1)).strftime('%Y-%m-%d %H:%M:%S')
cursor.execute("UPDATE events SET event_date = ? WHERE id = ?", (new_event_date, 1))
conn.commit()

# 再次查询并打印所有记录
cursor.execute("SELECT * FROM events")
rows = cursor.fetchall()
for row in rows:
    print(row)

# 关闭连接
conn.close()

event_date = datetime.now().strftime('%Y-%m-%d %H:%M:%S')

cursor.execute("SELECT strftime('%Y-%m-%d %H:%M:%S', event_date) FROM events")