MySQL把字符串字段转换为日期类型进行比较

MySQL把字符串字段转换为日期类型进行比较：select se5,s_number,d_number,transaction_date '签收时间',date_format(se3,'%Y-%m-%d %H:%i:%s') '出库时间',se3from dost where transaction_type in('销售出库','换货出库') and date_format(se3,'%Y-%m-%d %H:%i:%s') >= '2020-04-01' limit 10000;