如何从mysql数据库到下拉列表中获取排除'0000-00-00‘的最小日期

from flask import Flask, render_template
import mysql.connector

app = Flask(__name__)

@app.route('/')
def index():
    # 连接到MySQL数据库
    cnx = mysql.connector.connect(user='username', password='password',
                                  host='localhost', database='database_name')
    cursor = cnx.cursor()

    # 执行查询语句
    query = "SELECT MIN(date_column) FROM table_name WHERE date_column != '0000-00-00'"
    cursor.execute(query)

    # 获取查询结果
    result = cursor.fetchone()[0]

    # 构建下拉列表
    dropdown_list = "<select>"
    dropdown_list += "<option value='" + str(result) + "'>" + str(result) + "</option>"
    dropdown_list += "</select>"

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

    # 渲染模板并显示下拉列表
    return render_template('index.html', dropdown_list=dropdown_list)

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