sqlplus - SQL Help(Date Functions) -

i need on sql queries. table:

create table employees         ( employee_id   number(3) primary key,           first_name    varchar2(10),           last_name varchar2(10),           dept_code varchar2(3),           hire_date date,           credit_limit  number(4,2),           phone_ext varchar2(4),           manager_id    number(3)         ); 

entries:

insert employees values (201, 'susan', 'brown', 'exe', to_date('01-jun-1998','dd-mon-yyyy'), 30, '3484', null); insert employees values (202, 'jim', 'kern', 'sal', to_date('16-aug-1999','dd-mon-yyyy'), 25, '8722', 201); insert employees values (203, 'martha', 'woods', 'shp', to_date('02-feb-2004','dd-mon-yyyy'), 25, '7591', 201);     insert employees values (204, 'ellen', 'owens', 'sal', to_date('01-jul-2003','dd-mon-yyyy'), 15, '6830', 202); 

i need query list employees, hire dates , number of days each person have worked company of january 1, 2007.

you can use year() on date field:

select * employees year(hire_date)='2003' 

if doesn't work, can use extract():

select * employees extract(year hire_date)='2003' 

and, alan hadsell rightly commented:

select count(*) employees extract(year hire_date)='2003'