Difference between YYYY and RRRR

The difference between YYYY and RRRR is, YYYY Is used to show/fetch/store current year in 4 digit whereas RRRR assumes 2 digit year in the range of 0 to 49 in the current century and in the range of 50 to 99 are assume to be in the previous century.

YYYY format may not work for in below case:-

SELECT TO_CHAR(TO_DATE(’21-08-14’,’DD-MM-YYYY’),’DD-MM-YYYY’) DT FROM DUAL;

SELECT TO_CHAR(TO_DATE('21-08-51','DD-MM-YYYY'),'DD-MM-YYYY') DT FROM DUAL;

Let’s try to use RRRR format:-

SELECT TO_CHAR(TO_DATE(’21-08-14’,’DD-MM-RRRR’),’DD-MM-YYYY’) DT FROM DUAL;

SELECT TO_CHAR(TO_DATE('21-08-51','DD-MM-RRRR'),'DD-MM-YYYY') DT FROM DUAL;

But when you want to use only with YYYY format then you should not provide 4 digit year instate you can provide only 2 digit number as shown below:-

SELECT TO_CHAR(TO_DATE(’21-AUG-14’,’DD-MM-YY’),’DD-MM-YYYY’) DT FROM DUAL;

And below statement will not work for you:-

SELECT TO_CHAR(TO_DATE(’21-08-14’,’DD-MM-YYYY’),’DD-MM-YYYY’) DT FROM DUAL;

Read Also:-