Sql Server timestamp field

INSERT (OR) UPDATE STATEMENTS:

insert into customer (customer_id,timestamp) values (17982698, '2005-10-17T00:00:00.0');


SELECT STATEMENTS:

select count(*) from customer where timestamp >= convert(datetime, '2006/10/01') and issue_date <=convert(datetime, '2007/09/30');