Identify the correct output --- select ADD_MONTHS(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'), 6) from dual;

Keep practicing — related questions

• SELECT MONTHS_BETWEEN TO_DATE('02-01-1995','MM-DD-YYYY'),TO_DATE('01-01-1995','MM-DD-YYYY') ) FROM DUAL;
• SELECT TO_CHAR( ADD_MONTHS(to_date('07-JUN-1994,'DD-MON-YYYY'),1), 'DD-MON-YYYY') FROM employees WHERE last...
• Identify the correct output --- select LAST_DAY(TO_DATE('01-SEP-1995', 'DD-MON-YYYY')) from dual;
• What is the result of the query SELECT add_months('15-Jan-2011',-2) from DUAL ?
• Identify the correct output --- select TRUNC(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'),'YEAR') 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
• Answer the below query.. select to_date('01-01-51','DD-MM-YY') from dual ;