SQL & PL/SQL

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!

Date format as YYYYMM

user11961230Jul 28 2010 — edited Jul 28 2010

Hello Folks,
How can i get the date format as '201006'. I have tried to_char(trunc(sysdate,'MM')-1,'fmYYYYMM') but its not working. Can anyone tell me how to acheive this. Thanks a lot

This post has been answered by Frank Kulash on Jul 28 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2010

Added on Jul 28 2010

2 comments

6,955 views