What does the function months_between('02-feb-2001','01-jan-2001') return?

Keep practicing — related questions

• Which date function returns number value?
• Months_between will return negative numbers....
• SELECT MONTHS_BETWEEN TO_DATE('02-01-1995','MM-DD-YYYY'),TO_DATE('01-01-1995','MM-DD-YYYY') ) FROM DUAL;
• Find the function that returns the difference between two dates in terms of month.
• What is the result of the query SELECT add_months('15-Jan-2011',-2) from DUAL ?
• What is the output of DATE9. format?
• You are using SQL operations in Oracle. All of the following DATE functions return a DATE datatype except o...
• Identify the correct output --- select ADD_MONTHS(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'), 6) from dual;