Clicky

Dear fellow developers:

I have the following, working SQL statement:

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

Select allOpen 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.

asked 12/16/2011 03:56

fsyed's gravatar image

fsyed ♦♦


2 Answers:
datestring = to_char(TO_DATE(SUBSTR(CLOSINGINFO, 12, INSTR(CLOSINGINFO, ' at ') - 12), 'Day, Month DD, YYYY'),'MM/DD/YYYY')
link

answered

sdstuber's gravatar image

sdstuber

Thanks very much for your prompt reply, your solution worked (again)!  Full points!

Take care.
link

answered 2011-12-16 at 12:00:00

fsyed's gravatar image

fsyed

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×51
×17
×132

Asked: 12/16/2011 03:56

Seen: 244 times

Last updated: 12/16/2011 04:24