oracle 时间date 类型 like模糊查询例子

2019独角兽企业重金招聘Python工程师标准>>>

SELECT a.ID_, a.APPRAISAL_CYCLE_, a.HR_EFF_CYCLE_ID_, a.NAME_, a.PA_STIME_, a.OBJ_REPORT_STIME_, a.PA_ETIME_, a.OBJ_REPORT_ETIME_, a.HR_EFF_PFMCE_PLAN_ID_, a.STATUS_, a.CREATE_TIME_, a.MODIFY_TIME_, a.CREATOR_, a.MODIFIER_
        FROM HR_EFF_PPLAN_CYCLE a
         WHERE a.HR_EFF_PFMCE_PLAN_ID_='110000524000002'  
        and "TO_CHAR"(a.PA_STIME_,'yyyy-MM-dd') like '%2016-11-11%'
            
            and a.status_!='1' 
         
         
            ORDER BY a.ID_ DESC
 

转载于:https://my.oschina.net/u/2419285/blog/795403