关键函数是func.time_format
和func.date_format
包为from sqlalchemy.sql.functions import func
或from sqlalchemy import func
brush_data = session.query(RegisterOrder).filter(func.date_format('2020-03-21', "%Y-%m-%d") == func.date_format(RegisterOrder.trade_date, "%Y-%m-%d")).first()
brush_data = session.query(RegisterOrder).filter(func.time_format('18:09:31', "%H:%i:%S") == func.time_format(RegisterOrder.trade_time, "%H:%i:%S")).first()