Search operation on a table with multiple valuesWe perform search operation on a table based on multiple values. We have a column "CreatedDate" - smalldatetime, we insert including time Ex: 10/24/2017 2:09:00 PM.
But while searching we pass values from date, to date as "10/24/2017", "10/30/2017" respectively using between operator, but its not returning the result set.
select * from TestTable where (Location='Hyderabad') AND (EmpId='101') AND
(CreatedDate between @FromDate and @ToDate)
Thanks in advance