User Tools

Site Tools


kurs:datum_1

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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