|
最佳回答 |
|
0
|
Z4u3z1Lv6专家互助发布于2023-8-10 14:49（编辑于 2023-8-10 14:55）
|
${IF(LEN(qqjh_sdate)=0 && LEN(qqjh_edate)=0,"",(IF(LEN(qqjh_sdate)=0,CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")'," ---------- 没看懂 正常情况不这样写么： ${if(len(qqjh_sdate)==0,""," and TO_DATE(ZVDATU)>='"+qqjh_sdate+"'")} ${if(len(qqjh_edate)==0,""," and TO_DATE(ZVDATU)<='"+qqjh_edate+"'")} |
|
|
|
|
最佳回答 |
|
0
|
snrtuemcLv8专家互助发布于2023-8-10 14:50
|
${IF(LEN(qqjh_sdate)=0 && LEN(qqjh_edate)=0,"",(IF(LEN(qqjh_sdate)=0,CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")',"<= '"+qqjh_edate+"'"),CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")',">= '"+qqjh_sdate+"'"))} |
|
|
|
|
最佳回答 |
|
0
|
yzm180820Lv5初级互助发布于2023-8-10 14:53
|
${IF(LEN(qqjh_sdate)=0 && LEN(qqjh_edate)=0,"",(IF(LEN(qqjh_sdate)=0,CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")',"<= '"+qqjh_edate+"'"),CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")',">= '"+qqjh_sdate+"'"))} |
|
|
|
|
最佳回答 |
|
0
|
用户k6280494Lv6资深互助发布于2023-8-10 14:54（编辑于 2023-8-10 15:00）
|
${IF(LEN(qqjh_sdate)=0 && LEN(qqjh_edate)=0,"",IF(LEN(qqjh_sdate)=0,"and TO_DATE(ZVDATU) <= '"+qqjh_edate+"'","and TO_DATE(ZVDATU) >= '"+qqjh_sdate+"'"))} |
|
|
|
1min目标场景问卷
立即参与
${IF(LEN(qqjh_sdate)=0 && LEN(qqjh_edate)=0,"",(IF(LEN(qqjh_sdate)=0,CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")',"<= '${qqjh_edate}'"),CONCATENATE("and TO_DATE(",'\"',"ZVDATU",'\")',">= '${qqjh_sdate}'"))}改了下没有效果，是其他的地方出错了吗
