select date from varchar2
I have a table with a varchar2(4000) column that contains date information. Example is below:
Originator: Name
Location: Base
Text
AR#: 123-3456
Date Report Initiated: 2012-02-04 00:53:52
Initiator: name
Whenever I select this column the output looks like the above.
How do I search this column for date and select by that date?
thanks.
Originator: Name
Location: Base
Text
AR#: 123-3456
Date Report Initiated: 2012-02-04 00:53:52
Initiator: name
Whenever I select this column the output looks like the above.
How do I search this column for date and select by that date?
thanks.
0