源表数据集: SELECT *, DATE(zrdate) AS zrdate_date -- 新增一列用于存储转换后的 date 格式日期 FROM loan_list WHERE 1=1 AND DATE(zrdate) = '${申请日期}' -- 将 zrdate 转换为 date 格式进行比较 AND zrequester_id = ( SELECT realName FROM fine_user WHERE username = '${fine_username}' ) ${if(len(zid) == 0,"","AND zid = '" + zid + "'")} ${if(len(zprod_type) == 0,"","AND zprod_type = '" + zprod_type + "'")} ORDER BY zrdate desc; 子表页面: |