How To change mm/dd/yyyy format to mon/dd/yyyy in OBIEE11g

Hi All,

Scenario: In The DWH level data like this 01/22/2012 but in report level we display data like jan/22/2012.

Solution: we use Evaluate function to overcome to this type of situations.

EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ), EVALUATE('TO_DATE(%1,%2)' AS DATE ,EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ) ,"Time"."Date",'MM/DD/YYYY'),'MM/DD/YYYY'),'MON/DD/YYYY')

Here "Time"."Date" is Data column.