User Tools

Site Tools


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