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