Catch exception from to_date function : TO_DATE « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. TO_DATE
SQL>
SQL>
SQL> DECLARE
  2     bad_date EXCEPTION;
  3     PRAGMA EXCEPTION_INIT (bad_date, -01843);
  4  BEGIN
  5     DBMS_OUTPUT.PUT_LINE (TO_DATE ('13/13/99', 'MM/DD/YY'));
  6  EXCEPTION
  7    WHEN bad_date
  8    THEN
  9      DBMS_OUTPUT.PUT_LINE('Just twelve months in a year...');
 10  END;
 11  /
Just twelve months in a year...

PL/SQL procedure successfully completed.

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