DAYOFMONTH function in obiee
JUPSApr 1 2011 — edited Apr 1 2011Hi,
I have been trying to extract day of month,
DAYOFMONTH('03/03/2011'), this throws error saying
*nQSError: 10058] A general error has occurred. [nQSError: 22025] Function Calendar Extract is called with an incompatible type*
when i try DAYOFMONTH(CURRENT_DATE), the function is working fine, can anyone help me what date format does DAYOFMONTH expect as input parameter and how should i rephrase DAYOFMONTH('03/03/2011'), I also tried:
1. DAYOFMONTH(CAST('03/03/2011' AS DATE))
2. DAYOFMONTH(EVALUATE('TO_DATE(%1,%2)', '03/03/1999','DD/MM/YYYY'))
Thanks,
Sreekanth.