Thank you Sir. now i can proceed further. Thank you for your immense help....

Thank you very much. Thank you Sir. now i can proceed further...........

Your query is an immense help for me....... Thank you once again...

Thank u Sir. Ur query give me the result. But i need something little different result. When starting time is suppose 10:20:53, ur query gives me the result from 11:00:00...

Thank you Sir. I got it. I have just added this line to the query which you gave and i found the result

select * from tablename where DateTime >= dateadd(hh,datediff(hh,0,getdate()+'03:00:00'),0)...

Thank u sir, your query is an immense help for me. Now i can proceed further. But sir i want to ask you one more question. can u just tell...