how to convert a string date to date format in oracle10g

Question

My date value is stored as varchar2 and the value is 15 August 2009 4 30 PM  how to convert this to a proper date format like DD-MM-YYYY

User · Answer

You need to use the TO DATE function   SELECT TO DATE  01 01 2004    MM DD YYYY   FROM DUAL

User · Answer

You can convert a string to a DATE using the TO DATE function  then reformat the date as another string using TO CHAR  i e    SELECT TO CHAR           TO DATE  15 August 2009 4 30 PM                    DD Month YYYY HH MI AM            DD-MM-YYYY   FROM DUAL   15-08-2009   For example  if your table name is MYTABLE and the varchar2 column is MYDATESTRING   SELECT TO CHAR           TO DATE MYDATESTRING                   DD Month YYYY HH MI AM            DD-MM-YYYY   FROM MYTABLE

[oracle] how to convert a string date to date format in oracle10g

Examples related to oracle

Examples related to oracle10g

Examples related to plsqldeveloper