Hi abhi619,
You can use below query.
SQL
DECLARE @temp AS TABLE(Id INT,Name VARCHAR(30),logdate DATETIME)
INSERT INTO @temp VALUES
(1,'David','2015-07-14 17:15:19.750'),
(2,'Jhon','2015-07-12 17:15:25.750'),
(3,'Kevin','2015-07-18 17:20:19.750')
SELECT *
FROM @temp
WHERE CONVERT(VARCHAR(10),logdate,120) BETWEEN '2015-07-12' AND '2015-07-14'
Screenshot
