如何根据日期从2年记录中删除最近2个月的记录？

import datetime
import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 获取当前日期
current_date = datetime.date.today()

# 计算最近2个月的起始日期和结束日期
start_date = current_date - datetime.timedelta(days=60)
end_date = current_date - datetime.timedelta(days=1)

# 构建SQL查询语句
delete_query = "DELETE FROM your_table WHERE date_column BETWEEN %s AND %s"

# 执行SQL查询语句
cursor.execute(delete_query, (start_date, end_date))
cnx.commit()

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