Search code examples
oracleperformanceformulaoracle-apps

How to use SQL syntax in Oracle fast formula

I want to use extract(DAY from date) function in Oracle FastFormula. However I am getting error when I used above. Is there a similar seeded functionality that I can use for this purpose?

Solution

  • By looking at the function reference for OracleFormula, it seems that you have no other option than calling TO_CHAR with the appropriate format to achieve the desired result. based on the doc's example:

         mesg = 'Birthday is: ' + TO_CHAR (birthdate,
            'DD')