Get number of days between two dates in sql
You get number of days between two date using datediff function
Select datediff(Day, date_1,date_2) as NoOfDays
From table