Oracle Analytics Server (OAS) (MOSC) READ-ONLY

MOSC Banner

How to cast date in derived column using format mask?

edited Apr 5, 2019 5:28PM in Oracle Analytics Server (OAS) (MOSC) READ-ONLY 6 commentsAnswered ✓

My customer has asked me to define a column in the RPD that uses to_char and a format mask to display the date in a MMYY format.  I found the following post in this forum from 2013 which has not been answered:  https://community.oracle.com/thread/3391431?q=cast%20date%20formatmask

So, I decided it may be best to repost in hopes of getting a second look.  I'll be happy to update the other post if the answer is found here. 

Here is the derived column that they want defined:

decode(cog, 'AA', to_char(test_date, 'MMYY'), decode(code, 'C', to_char(run_date, 'MMYY'), decode (code, 'E', to_char(run_date, 'MMYY'), to_char(expire_date, 'MMYY'))))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center