It's all about the answers!

Ask a question

BIRT FILTER FOR DAY OF THE WEEK FROM RTC TIMESTAMP


Green Elk (136) | asked Oct 24 '16, 6:29 a.m.
 Hi,

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 TIMESTAMP?

Something like....

PROJECT_AREA_NAME = '{Current Project Area}' AND ITERATION_NAME = ITNAME AND WI_TYPE = 'Bug'  AND DAYOFTHEWEEK(TIMESTAMP) = 1

Thanks in advance
John

Be the first one to answer this question!


Register or to post your answer.