TO_DATE('1-1-1998','mm-dd-yyyy') : TO_DATE « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. TO_DATE

SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2    d1    DATE;
  3    d2    DATE;
  4    d3    DATE;
  5    d4    DATE;
  6    n1    NUMBER;
  7    n2    NUMBER;
  8    n3    NUMBER;
  9   BEGIN
 10    d2 := TO_DATE('1-1-1998','mm-dd-yyyy');
 11
 12    DBMS_OUTPUT.PUT_LINE('d2 = ' || TO_CHAR(d2,'dd-Mon-yyyy'));
 13
 14  END;
 15  /
d2 = 01-Jan-1998

PL/SQL procedure successfully completed.

SQL>
SQL>