Get number of days between two dates in sql

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