The output of the below two queries will be same. 1.select to_date('01-01-00','DD-MM-YY') from dual 2.select to_date('01-01-00','DD-MM-RR') from dual
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Answer the below query.. select to_date('01-01-51','DD-MM-RR') from dual
- Answer the below query.. select to_date('01-01-51','DD-MM-YY') from dual ;
- SELECT MONTHS_BETWEEN TO_DATE('02-01-1995','MM-DD-YYYY'),TO_DATE('01-01-1995','MM-DD-YYYY') ) 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
- Identify the correct output --- select LAST_DAY(TO_DATE('01-SEP-1995', 'DD-MON-YYYY')) from dual;
- Identify the correct output --- select ADD_MONTHS(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'), 6) from dual;
- Identify the correct output --- select TRUNC(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'),'YEAR') from dual;