SQL DATE PART

DATEADD (datepart , number , date )

DartPart day=day
wk=week
MONTH=month
YEAR=year
number increase or decrease the value

declare @DT datetime

SET @DT=DATEADD(day,-1,getdate())
print @DT

SET @DT=DATEADD(wk,1,getdate())
print @DT

SET @DT=DATEADD(MONTH,1,getdate())
print @DT

SET @DT=DATEADD(YEAR,1,getdate())
print @DT


Get the date part

DATEPART ( datepart , date )
DAY ( date )
MONTH( date )
YEAR( date )
DATEPART(Year,getdate())

get the name of month

declare @DT varchar(50)

set @DT=DATENAME  (month,getdate())
print @DT


Difference between start date and enddate

DATEDIFF ( datepart , startdate , enddate )

declare @DT int

SET @DT=DATEDIFF(wk,@startdate,@enddate)
print @DT