How to parse a varchar2 column and insert date data into another column?
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 21, 2008 3:52 PM
UPDATED:
August 21, 2008 5:04 PM
RELATED QUESTIONS
- SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
- Pass table name to procedure including fields
- Access 2007 database query question
- ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g
- Create "if then" formula in Access 2003
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
