title: Write a SQL Query to find year from date
body: <p>First of all I've try to do this query, in different format. but, I have not get any solution. so, i wants to solve this doubt in particular method and different method. And I want the exact solution this table.</p>
  
  <p><strong>Write a SQL Query to find  year from date.</strong></p>
  
  <pre><code>SELECT YEAR(GETDATE()) as "Year";
  </code></pre>
  
  <hr>
  
  <pre><code>   o_id         no.order          o_date         amount 
      --------------------------------------------------
      2             6                1-2-11         120
      3             7                2-2-11         130
      5             5                3-2-11         100
      6             1                4-2-11         50
  </code></pre>
  
  <p>note: <a href="http://java67.blogspot.in/2013/04/10-frequently-asked-sql-query-interview-questions-answers-database.html" rel="nofollow">the source getting from</a></p>