Skip to Main Content
Forums

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!

Oracle Current month

Venkat KrishnaDec 16 2011 — edited Dec 16 2011
Hi Experts,

I have a date dimension table in database.

I want o have sql query something like below which returns current month from Database which is equal to sysdate current month


select distinct X.MO_FULL_NM
from X
where X.MO_FULL_NM =TO_char(sysdate,'MONTH') Not working

Can someone helps with the exact format.

Thanks in Advance

V
This post has been answered by AlanWms on Dec 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2012
Added on Dec 16 2011
5 comments
8,179 views