Hi nandish,
Refer below sample query.
DECLARE @Test AS TABLE(ft_id INT, from_date VARCHAR(45), to_date VARCHAR(45), cost VARCHAR(45))
INSERT INTO @Test VALUES(1,'05-05-2017','15-05-2017','60')
INSERT INTO @Test VALUES(2,'05-05-2017','10-05-2017','50')
INSERT INTO @Test VALUES(3,'05-05-2017','15-05-2017','70')
SELECT * FROM @Test
WHERE GETDATE() BETWEEN CONVERT(DATETIME,from_date,105) AND CONVERT(DATETIME,to_date,105)
Output
ft_id |
from_date |
to_date |
cost |
1 |
05-05-2017 |
15-05-2017 |
60 |
3 |
05-05-2017 |
15-05-2017 |
70 |