从datetime-local html输入插入到PSQL DB中

<input type="datetime-local" name="datetime" id="datetime">

from flask import Flask, request
import psycopg2

app = Flask(__name__)

@app.route('/insert_datetime', methods=['POST'])
def insert_datetime():
    datetime = request.form['datetime']
    
    # 连接到PSQL数据库
    conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
    cursor = conn.cursor()
    
    # 执行插入操作
    cursor.execute("INSERT INTO your_table (datetime_column) VALUES (%s)", (datetime,))
    
    # 提交事务并关闭连接
    conn.commit()
    cursor.close()
    conn.close()
    
    return "Datetime inserted successfully"

if __name__ == '__main__':
    app.run()