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!

understanding of MOD function

marcoAug 2 2011 — edited Aug 2 2011

Hi all,

I'm not familiar with MOD function, could someone please explain how does it work.

Actually, why

select months_between(trunc(sysdate+125,'MM'),trunc(sysdate+125,'Q')) from dual

and

select mod(to_char(sysdate+125, 'mm') - 1, 3) from dual

return the same value?

This post has been answered by Hoek on Aug 2 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2011

Added on Aug 2 2011

4 comments

531 views