title: How to only get Year as part of date / datetime in SQL Server
body: <p>When I create a date type in SQL, the result will come out like this <code>2012-2-1 Monday 00:00:00</code></p>
  
  <p>However, I only want the year.</p>
  
  <p>How can I get this?</p>