SELECT MONTHS_BETWEEN TO_DATE('02-01-1995','MM-DD-YYYY'),TO_DATE('01-01-1995','MM-DD-YYYY') ) FROM DUAL;
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Identify the correct output --- select ADD_MONTHS(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'), 6) from dual;
- SELECT TO_CHAR( ADD_MONTHS(to_date('07-JUN-1994,'DD-MON-YYYY'),1), 'DD-MON-YYYY') FROM employees WHERE last...
- Answer the below query.. select to_date('01-01-51','DD-MM-YY') from dual ;
- Answer the below query.. select to_date('01-01-51','DD-MM-RR') from dual
- What's the output select to_Date('2009-may-25','yyyymmdd') from dual
- What's the output select to_Date('2009-may-25','yyyymmdd') from dual
- What is the result of the query SELECT add_months('15-Jan-2011',-2) from DUAL ?
- Identify the correct output --- select LAST_DAY(TO_DATE('01-SEP-1995', 'DD-MON-YYYY')) from dual;