select where with datetime

Question

select * from tbl_theodoi_hangbosung WHERE hoantat=1 AND cast ([ngayhoantat] as date)>='20161111' AND cast ([ngayhoantat] as date)<='20161111'