Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle date format

Saipraneeth IruguOct 31 2012 — edited Nov 1 2012

Hi,

I am trying to get the month number from this date format '19-OCT-12' . when i try to run the below statement i am getting an error like "not a valid month"

select to_date('19-OCT-12','MM') from dual

i need to get value as 10 can you please help me.

Regards

This post has been answered by Osama_Mustafa on Oct 31 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2012

Added on Oct 31 2012

#general-database-discussions

4 comments

197 views