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