oracle之时间格式的应用

${if(len(start_date)==0,""," and rs.count_date >= '"+start_date+"'||' 00:00:00'")}
${if(len(end_date)==0,""," and rs.count_date <= '"+end_date+"'||' 23:59:59'")}



${if(len(ldt_commitTimeBg)==0,""," and to_date(to_char(rdnc.commit_date,'yyyy-MM-dd'),'yyyy-MM-dd') =
to_date('"+ldt_commitTimeBg+" ', 'yyyy-mm-dd ')")}






${if(len(ldt_commitTimeBg)==0,""," and to_date(t.return_time,'YYYY-MM-DD hh24:mi:ss') >=
to_date('"+ldt_commitTimeBg+"'||' 00:00:00', 'YYYY-MM-DD hh24:mi:ss')")}
${if(len(ldt_commitTimeEd)==0,""," and to_date(t.return_time,'YYYY-MM-DD hh24:mi:ss') <=
to_date('"+ldt_commitTimeEd+"'||' 23:59:59', 'YYYY-MM-DD hh24:mi:ss')")}




${if(len(ldt_commitTimeBg)==0,""," and t.order_date>=to_date('"+ldt_commitTimeBg+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeEd)==0,""," and t.order_date<=to_date('"+ldt_commitTimeEd+"','YYYY/MM/DD')")}





${if(len(ldt_commitTimeBg)==0,""," and t.order_date>=to_date('"+ldt_commitTimeBg+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeEd)==0,""," and t.order_date<=to_date('"+ldt_commitTimeEd+"','YYYY/MM/DD')")}






${if(len(commitStartTime)==0,""," and to_date(oif.finish_time,'YYYY-MM-DD hh24:mi:ss') >=
to_date('"+commitStartTime+"'||' 00:00:00', 'YYYY-MM-DD hh24:mi:ss')")}
${if(len(commitEndTime)==0,""," and to_date(oif.finish_time,'YYYY-MM-DD hh24:mi:ss') <=
to_date('"+commitEndTime+"'||' 23:59:59', 'YYYY-MM-DD hh24:mi:ss')")}





${if(len(start_date) ==0,""," and  substr(oif.commit_time,1,7) = '" +start_date +"'")}






${if(len(ldt_commitTimeBg)==0,""," and to_date(o.commit_time,'YYYY-MM-DD hh24:mi:ss') >=
to_date('"+ldt_commitTimeBg+"'||' 00:00:00', 'YYYY-MM-DD hh24:mi:ss')")}
${if(len(ldt_commitTimeEd)==0,""," and to_date(o.commit_time,'YYYY-MM-DD hh24:mi:ss') <=
to_date('"+ldt_commitTimeEd+"'||' 23:59:59', 'YYYY-MM-DD hh24:mi:ss')")}





 

${if(len(ldt_commitTimeBg)==0,""," and o.commit_time >= '"+ldt_commitTimeBg+"'||' 00:00:00'" )}
${if(len(ldt_commitTimeEd)==0,""," and o.commit_time <= '"+ldt_commitTimeEd+"'||' 23:59:59'" )}





${if(len(start_date)==0,""," and substr(vsms.order_commit_date,1,7) >= '"+start_date+"'")}






and oit.is_delete='N'
${if(len(queryCommitTimeBg)==0,""," and o.commit_time>='"+queryCommitTimeBg+"' || ' 00:00:00'")}

${if(len(queryCommitTimeEd)==0,""," and o.commit_time<= '"+queryCommitTimeEd+"' || ' 23:59:59'")}





${if(len(ldt_commitTimeBg)==0,""," and t.order_date>=to_date('"+ldt_commitTimeBg+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeEd)==0,""," and t.order_date<=to_date('"+ldt_commitTimeEd+"','YYYY/MM/DD')")}





 

${if(len(ldt_commitTimeBg)==0,""," and o.commit_time >= '"+ldt_commitTimeBg+"'||' 00:00:00'" )}
${if(len(ldt_commitTimeEd)==0,""," and o.commit_time <= '"+ldt_commitTimeEd+"'||' 23:59:59'" )}

 

转载于:https://www.cnblogs.com/wangchuanfu/p/5976534.html