Convert varchar2 to Date MM DD YYYY in PL SQL

Question

I need to convert string from varchar to Date in  MM DD YYYY  format  My input string is  4 9 2013  and my expected output is  04 09 2013   i e  2 digit month  2 digit date and 4 digit year seperated by     I have below data  DOJ varchar2 10 Byte column has  4 9 2013  value  I am using  select TO DATE DOJ  MM DD YYYY   from EmpTable  But I am getting result as 09-APR-13  I want it in 04 09 2013 format   Please advise  Thanks in advance

User · Answer

First you convert VARCHAR to DATE and then back to CHAR  I do this almost every day and never found any better way   select TO CHAR TO DATE DOJ  MM DD YYYY     MM DD YYYY   from EmpTable

User · Answer

Easiest way is probably to convert from a VARCHAR to a DATE  then format it back to a VARCHAR again in the format you want   SELECT TO CHAR TO DATE DOJ  MM DD YYYY     MM DD YYYY   FROM EmpTable    An SQLfiddle to test with

User · Answer

Example query   SELECT TO CHAR TO DATE  2017-08-23   YYYY-MM-DD     MM DD YYYY   FROM dual

[date] Convert varchar2 to Date ('MM/DD/YYYY') in PL/SQL

Examples related to date

Examples related to plsql

Examples related to format