如图1: 以下是我的sql语句 SELECT t1.ZJSL, t2.FYDSL, t2.YEAR, t2.MONTH, t2.DAY, TO_DATE(t2.YEAR || '-' || t2.MONTH || '-' || t2.DAY, 'YYYY-MM-DD') AS TIME FROM t1 LEFT JOIN t2 ON t1.YEAR = t2.YEAR AND t1.MONTH = t2.MONTH WHERE 1=1 ${if(len(start_time)=0,"","and T2.year || '-'|| T2.month||'-'||T2.day>='"+start_time+"'")} ${if(len(end_time)=0,"","and T2.year || '-'|| T2.month||'-'||T2.day <='"+end_time+"'")} ORDER BY t2.YEAR, t2.MONTH 更新后台查询数据如下: |