title: Extracting details from a database timestamp
body: <p>I'm learning about timestamps. I can find lots of infomation about extracting data from current timestamps but little about querying a database timestamp. For example, I'd like to perform the following (the syntax is not correct, but should hopefully illustrate my question)</p>
  
  <pre><code>SELECT * FROM database where timestamp DAY('12') AND MONTH('01')
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT * FROM database where timestamp MONTH('01') AND YEAR('2009')
  </code></pre>
  
  <p>can you point me in the right direction?</p>