title: Oracle SQL WHERE MONTH = N
body: <p>In my select I am using this</p>
  
  <pre><code>(TRUNC(TO_DATE(TIMESTAMP, 'dd.mm.yyyyHH24:mi'))) TIMESTAMP,
  </code></pre>
  
  <p>to get the following output in a date format: e.g. <code>22/04/2016</code></p>
  
  <p>Now I want to add a statement in my WHERE-clause to show only dates in special months, for example only dates which are in MARCH and APRIL</p>
  
  <p>I tried using this:</p>
  
  <pre><code>WHERE (TRUNC(TO_DATE(TIMESTAMP, 'mm'))) in (3,4) 
  </code></pre>
  
  <p>which gives me an error.</p>
  
  <p>Thanks for helping.</p>