title: Can someone help me convert this sqlite query to a postgres query?
body: <pre><code>SELECT substr(strftime('%Y', date),3,2) AS month, 0 AS zero FROM listvalue
  </code></pre>
  
  <p>I have this query in SQLite, when I import it into Postgres I'm having problem translating the <code>substr(strftime('%Y', date),3,2)</code> part.</p>