You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trying to create an OTBI Filter to convert string to DATE with current YEAR

Accepted answer
219
Views
2
Comments

Summary:

Hi, I am trying to create an OTBI analyses that takes a DFF ATTRIBUTE5 in text format with the month and day, and then compares it to the date of the current year . The DFF ATTRIBUTE5 is text format and would have the format "mm-dd" e.g. "11-24"

I found the function to convert a string into a DATE is : DATE 'yyyy-mm-dd'

I then can find the current year, YEAR(CURRENT_DATE) , but I cannot seem to find the correct format .

Content (required):

This is the normal SQL where :

TO_DATE(EXTRACT(YEAR FROM SYSDATE)||'-'||ATTRIBUTE5,'yyyy-mm-dd') = trunc(sysdate)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!