Need help modifying SQL statement for Oracle

Dear fellow developers:

I have the following, working SQL statement:

CLOSEDATE = TO_DATE(SUBSTR(CLOSINGINFO, 12, INSTR(CLOSINGINFO, ' at ') - 12), 'Day, Month DD, YYYY')

Open in new window


The column "CLOSEDATE" is of type "Date".  What I need to do is also include this same date value in another column called "DATESTRING" that is of type VARCHAR2.  I need this date value to be of the form MM/DD/YYYY in this column.  How do I modify the above sql statement to accomplish this?

Thanks in advance to all who reply.
fsyedAsked:
Who is Participating?
 
sdstuberCommented:
datestring = to_char(TO_DATE(SUBSTR(CLOSINGINFO, 12, INSTR(CLOSINGINFO, ' at ') - 12), 'Day, Month DD, YYYY'),'MM/DD/YYYY')
0
 
fsyedAuthor Commented:
Thanks very much for your prompt reply, your solution worked (again)!  Full points!

Take care.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.