DATEPART

DATEPART allows you to retrieve components of a date.

You can extract also YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.

 DATEPART(YEAR, d)    DATEPART(MONTH, d)
 DATEPART(DAY, d)     DATEPART(HOUR, d)
 DATEPART(MINUTE, d)  DATEPART(SECOND, d) 

SELECT whn
      ,DATEPART(YEAR, whn)  AS yr
      ,DATEPART(MONTH, whn) AS mnth
  FROM eclipse

• + (date)