Using the YY Format : TO_DATE « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. TO_DATE

If you use the YYYY format but only supply a two-digit date, the date is interpreted using the YY format.

In this case, the century for your year is assumed to be the same as the present century currently set on your database server.

which means, first two digits of your supplied year are set to the first two digits of the present year.

SQL> SELECT
  2    TO_CHAR(TO_DATE('04-JUL-25', 'DD-MON-YY'), 'DD-MON-YYYY'),
  3    TO_CHAR(TO_DATE('04-JUL-85', 'DD-MON-YY'), 'DD-MON-YYYY')
  4  FROM dual;

TO_CHAR(TO_ TO_CHAR(TO_
----------- -----------
04-JUL-2025 04-JUL-2085

SQL>








13.21.TO_DATE
13.21.1.Specifying a Datetime Format for TO_DATE() function
13.21.2.Using the YY Format
13.21.3.Using the RR Format
13.21.4.TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-RR'), 'DD-MON-YYYY')
13.21.5.TO_DATE function to convert from characters to dates explicitly
13.21.6.TO_DATE(x[, format]) converts the x string to a datetime
13.21.7.TO_DATE() converts the strings 04-JUL-2006 to the date July 4, 2006
13.21.8.Specifying Times
13.21.9.TO_DATE() with INSERT statement
13.21.10.DBMS_OUTPUT.PUT_LINE(TO_DATE ('1/1'));
13.21.11.DBMS_OUTPUT.PUT_LINE(TO_DATE ('6/1996'));
13.21.12.DBMS_OUTPUT.PUT_LINE(TO_DATE ('12-APR-09'));
13.21.13.DBMS_OUTPUT.PUT_LINE(TO_DATE ('19991205'));
13.21.14.DBMS_OUTPUT.PUT_LINE(TO_DATE ('1/1/1'))
13.21.15.Birthday before 1940
13.21.16.Catch exception from to_date function