select run_id,CREATE_TIME, TIMESTAMPDIFF(day,CREATE_TIME,sysdate()) as tian, TIMESTAMPDIFF(hour,CREATE_TIME,sysdate()) as xiaoshi from bpm_run_prcs where TIMESTAMPDIFF(hour,CREATE_TIME,sysdate()) >500
select run_id,CREATE_TIME, TIMESTAMPDIFF(day,CREATE_TIME,sysdate()) as tian, TIMESTAMPDIFF(hour,CREATE_TIME,sysdate()) as xiaoshi from bpm_run_prcs where TIMESTAMPDIFF(hour,CREATE_TIME,sysdate()) >500