如何在Sql server 2008R2中搜索datetime

i am having problem with a sql search . i am trying to search with the help of datetime because in my project time is very important. when i use query like thisi am having problem with a sql search . i am tr