在python中对mysql数据库获取的日期执行操作

import mysql.connector
from datetime import datetime

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 执行SQL查询获取日期
query = "SELECT date_column FROM your_table WHERE id = %s"
cursor.execute(query, (1,))  # 假设我们要获取id为1的记录的日期

result = cursor.fetchone()
if result:
    # 获取到的日期是字符串格式，需要转换为datetime对象
    date_str = result[0]
    date_obj = datetime.strptime(date_str, '%Y-%m-%d')
    
    # 对日期进行操作，例如增加一天
    new_date = date_obj + timedelta(days=1)
    
    print("原始日期:", date_obj)
    print("新日期:", new_date)

cursor.close()
db.close()

# 使用参数化查询防止SQL注入
query = "SELECT date_column FROM your_table WHERE id = %s"
cursor.execute(query, (user_input_id,))