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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Need query to convert string to date format 'MM/DD/YYYY'

Summary:

I need the results in TO_DATE format for the below query:

SELECT TO_CHAR(trunc(sysdate, 'Q'),'MM/DD/YYYY') AS QSD FROM DUAL

it's generating results for string, need the result in date format like MM/DD/YYYY for flow patterns.


Content (required):

Need query to convert string to date format 'MM/DD/YYYY'


Version (include the version you are using, if applicable):

22A


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT TO_CHAR(trunc(sysdate, 'Q'),'MM/DD/YYYY') AS QSD FROM DUAL

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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