This shows you the differences between two versions of the page.
kurs:datum_1 [2014/09/10 21:22] |
kurs:datum_1 [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | SELECT employees.hire_date, employees.employee_id, employees.first_name, last_name | ||
+ | FROM employees | ||
+ | -- where extract(year from hire_date) = '1994' -- (select to_char(hire_date, 'YYYY') from employees where employee_id = 203) | ||
+ | where hire_date between to_date('1993', 'yyyy') and to_date( '1995','yyyy') | ||
+ | -- where to_char(hire_date, 'YYYY') between '1994' and '1995' | ||
+ | ORDER BY employees.hire_date ASC | ||
+ | </code> |