How to get the Year Period as per the currentDate(GetDate())

Hi Basit Khan,

Day count: select DATEDIFF(DD,JoinDate,GETDATE()) from Employee

Month count: select DATEDIFF(month,JoinDate,GETDATE()) from Employee

Year count: select DATEDIFF(year,JoinDate,GETDATE()) from Employee

datepart format

year yy, yyyy

quarter qq, q

month mm, m

dayofyear dy, y

day dd, d

week wk, ww

weekday dw, w

hour hh

minute mi, n

second ss, s

millisecond ms

microsecond mcs

nanosecond ns

if your problem solve accept ans.