title: Getting data year wise in oracle
body: <p>I need result for specific year while querying a DATE column</p>
  
  <p>for ex:</p>
  
  <pre><code>         select year_last_renovated from project 
           where year_last_renovated='2014';
  </code></pre>
  
  <p>NOTE: YEAR_LAST_RENOVATED is DATE datatype.</p>