This shows you the differences between two versions of the page.
— |
kurs:overlaps [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | 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 | ||
+ | |||
+ | </code> |