oracle时间date类型like模糊查询例⼦四神瓦当
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
雅兹迪