SQL SERVER some Date functions

Select GetDate() //Get Current Date 
 
Select Dateadd(dd,2,getdate()) //Add 2 days from Current Date

Select Datediff(dd,'1985-05-06','2005-06-09') //Get Date
difference between those days

Select Datepart(dd,getdate()) //get a date only from currentdate