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!

MONTHS_BETWEEN function returns 'wrong' negative values ???

user13393428Aug 21 2013 — edited Nov 28 2013

Hi,

I can't figure out why these values are results.

SQL> select months_between(to_date('02-FEB-13','DD-MON-RR'), to_date('28-FEB-13','DD-MON-RR')) from dual;

MONTHS_BETWEEN(TO_DATE('02-FEB-13','DD-MON-RR'),TO_DATE('28-FEB-13','DD-MON-RR')

--------------------------------------------------------------------------------

                                                                     -.83870968

SQL> select months_between(to_date('02-FEB-13','DD-MON-RR'), to_date('01-APR-13','DD-MON-RR')) from dual;

MONTHS_BETWEEN(TO_DATE('02-FEB-13','DD-MON-RR'),TO_DATE('01-APR-13','DD-MON-RR')

--------------------------------------------------------------------------------

                                                                     -1.9677419

SQL> select months_between(to_date('02-FEB-13','DD-MON-RR'), to_date('02-APR-13','DD-MON-RR')) from dual;

MONTHS_BETWEEN(TO_DATE('02-FEB-13','DD-MON-RR'),TO_DATE('02-APR-13','DD-MON-RR')

--------------------------------------------------------------------------------

                                                                             -2
This post has been answered by BluShadow on Aug 21 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2013
Added on Aug 21 2013
#sql, #value
10 comments
1,372 views