title: Sqlite Query how to get the all the entry from the year
body: <p>I need to get all the entries in a sqlite database that match the current year? how do I do that do I that.</p>
  
  <p>Here is my code but it's return 0</p>
  
  <p>My table structure looks like this:</p>
  
  <pre><code>id | name | tt_date
  ____________________
  1  | test1 | {ts '2016-02-11 00:00:00'}
  2  | test2 | {ts '2016-02-11 00:00:00'}
  </code></pre>
  
  <p>Here is my query:</p>
  
  <pre><code>select * FROM tt WHERE strftime('%Y', tt_date) = strftime('%Y', 'now')
  </code></pre>
  
  <p>but it returns 0 in the reults</p>