Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need query to convert string to date format 'MM/DD/YYYY' — Cloud Customer Connect
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

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

Received Response
1
Views
6
Comments

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!