title: select all years that greater than 5 years ago from year today
body: <pre><code> a          b
   1          2009
   2          2007
   3          2006
   4          2010
   5          2011
  </code></pre>
  
  <p>How I will select all years that greater than 5 years ago from year today?</p>
  
  <pre><code>So it would be like 2013(year today) - 5 = 2008
   a          b
   1          2009
   4          2010
   5          2011
  </code></pre>
  
  <p>I tried this:</p>
  
  <pre><code>select * from table1 where b &gt; CURRENT_TIMESTAMP - 5
  </code></pre>
  
  <p>I use smallint as datatype of column b instead of date because I will only store the year. Is it safe to use small int for storing year?</p>