dokuwiki

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