SQL Server DateDiff Function
–Date Difference Function
–Number of days between two dates
select datediff(day,getdate(),’09/01/2020′)
–Number of months between two dates
select datediff(month,getdate(),’09/01/2020′)
–Number of years between two dates
select datediff(year,getdate(),’09/01/2020′)
#SQLServer