select last_name, hire_date, hire_date + to_yminterval('1-0') end_date from employees where (hire_date, hire_date + to_yminterval('1-0')) overlaps (to_date('20030501', 'yyyymmdd'), to_date('20051015', 'yyyymmdd')) order by hire_date