How to parse a varchar2 column and insert date data into another column?

25 pts.
Tags:
Oracle Parse Date
I'm working on a database that has an important date stored in a notes column that is varchar2. The date is always in the same position in the column. Does anyone know a function or a way I could pick the date out of this column and use it to update a date in another date column? Thanks for your replies. This is on Oracle 10.2.0.3. Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I am thinking substr would work if it is always in the same location.

substr(notes_field, start_position_number, length_of_date) that will get you the string version of the date then just run a to_date function on it. May have to play with the length and grab some additional whitespace ( 4/4/2008 vs 04/04/2008) . Examples of the data would be helpful.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following