title: PostgreSQL, checking date relative to "today"
body: <p>Was wondering if someone could assist with some Postgres. I have a table which has a column called <code>mydate</code> which is a postgres date type. I want to do something like:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE mydate &gt; [Today-1year]
  </code></pre>
  
  <p>I've never used Postgres before and I'm sure I just need to know the name of some functions- I'll gladly look up the reference myself. Can anyone point me in the right direction?</p>
  
  <p>Thanks!</p>