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!

How to extract actual month number

mr_robot98Mar 1 2018 — edited Mar 1 2018

Hi everyone!

I'm new with oracle sql and I need some help...

I want to sum 12 to the current month number...so if we are in March, i would to compare a field with this result (3+12).

It's correct to do this?

SUM (TO_NUMBER(TO_CHAR(SYSDATE,'MM'))+12)

Thank you!

This post has been answered by Frank Kulash on Mar 1 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2018

Added on Mar 1 2018

#sql

8 comments

2,760 views