select * from per_all_people_f papf where trunc(sysdate) between trunc(papf.effective_start_date) and trunc(papf.effective_end_date) and papf.employee_number = 145;
trunc sysdate
原文：http://www.cnblogs.com/rigid/p/4153902.html
