使用Python代码将带偏移量的日期插入PostgreSQL数据库

import psycopg2
from datetime import datetime, timedelta

def generate_offset_date(offset):
    current_date = datetime.now()
    offset_date = current_date + timedelta(days=offset)
    return offset_date

conn = psycopg2.connect(
    host="your_host",
    database="your_database",
    user="your_username",
    password="your_password"
)

cur = conn.cursor()

offset_date = generate_offset_date(7)  # 偏移量为7天
cur.execute("INSERT INTO your_table (date_column) VALUES (%s)", (offset_date,))

conn.commit()
cur.close()
conn.close()