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/ouminzy/blog/795403