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