User Tools

Site Tools


kurs:overlaps
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
kurs/overlaps.txt · Last modified: 2014/09/10 21:22 (external edit)