select * from oa_schedule b
where b.task_id in(
select a.wf_orunid from BPM.BPM_ArchivedData a
where a.wf_processid ='f4bc174a0f48d042f00a0e70eb26e5a0c733'
) and
--开始时间等于系统时间加上一天,为获得第二天的数据
(SELECT TO_CHAR(b.start_time / (1000 * 60 * 60 * 24) +
TO_DATE('1970-01-01', 'YYYY-MM-DD'), 'YYYY-MM-DD') AS CDATE
from dual)=
(select to_char(sysdate+1,'YYYY-mm-dd')
from dual)