Thank u Sir for your immense help but when i execute the query i did not get any result. I want to ask one more question, whether the query must match the exact time i.e in hours, minute and seconds.

Actually can we do some kind of casting to match only the exact hours only, so that it will check for the hours from the Time column and get the data.

Thank you once again.