Skip to Main Content

LiveLabs & Workshops

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!

How to retrieve the current month data from Oracle SQL?

Venkatesh K JDec 12 2022

select * from payments where paydate=trunc(sysdate,'mm'); i tried this code but it's showing no data found in Oracle SQL but i have two records in Dec months. Help on this.

Comments
Post Details
Added on Dec 12 2022
1 comment
7,273 views