find date bet two date in sql

Question

Hello I have column with value To_Date july 2015 jun 2015 Aug 2015 Jun 2016 and i want the record which is from current month and year To next 2 month and year means i want record from jun 2015 To Aug 2015

Manoj Bhoir · Answer

Hi You have not specified your To_Date column Data Type. I hope it is Date . You can try this query : Select * From TableName Where To_Date BETWEEN FORMAT(GETDATE() 'yyyy-MM-01') AND FORMAT(DATEADD(M 2 GETDATE()) 'yyyy-MM-01')