BIRT FILTER FOR DAY OF THE WEEK FROM RTC TIMESTAMP
<p>I want to write a birt filter to just get database entries for a particular day of the week/month. I want to filter them at source. Is there any "sql like" syntax that allows to get the day of the week from <code>TIMESTAMP</code>?</p>

<p>Something like....</p>

<pre><code>PROJECT_AREA_NAME = '{Current Project Area}' AND ITERATION_NAME = ITNAME AND  WI_TYPE = 'Bug'  AND DAYOFTHEWEEK(TIMESTAMP) = 1
</code></pre>

<p>Thanks in advance
John</p>