Convert YYYY-MM-DD to oracle date data type format

Hi Experts,
I have a alphanumeric type for date as 'YYYY-MM-DD' that I need to convert to Oracle date type format. Below is what I am trying to do in oracle but it gives error. Please suggest.

select to_date('2012-01-30','mm/dd/yyyy')
from dual
Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Use the correct format mask:

select to_date('2012-01-30', 'YYYY-MM-DD') from dual;
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.