convert char to date in oracle

There is an old oracle audit table in oracle that has data for a date in varchar format
The value is stored as 01/20/2011 00:00
Now I want to take this column as date. The column name is old_value
Table is campaign_donors_audit.
LVL 6
anumosesAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
select to_date(old_value,'mm/dd/yyyy hh24:mi') from campaign_donors_audit
0
 
slightwv (䄆 Netminder) Commented:
just use to_date:

to_date(old_value,'MM/DD/YYYY HH24:MI')
0
 
subratabiswasCommented:
select to_date('01/20/2011 00:00', 'mm-dd-rrrr HH24:MI') from dual for your example
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.