Oracle SQL WHERE MONTH = N
<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>