TO_DATE('Jan 1, 2000','mon dd, yyyy') : TO_DATE « PL SQL Programming « Oracle PL/SQL Tutorial






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    d3 := TO_DATE('Jan 1, 2000','mon dd, yyyy');
 11
 12    DBMS_OUTPUT.PUT_LINE('d3 = ' || TO_CHAR(d3,'Day, Month dd, yyyy'));
 13
 14  END;
 15  /
d3 = Saturday , January   01, 2000

PL/SQL procedure successfully completed.








24.7.TO_DATE
24.7.1.Use TO_DATE function in PL/SQL
24.7.2.TO_DATE('1/1/02','mm/dd/yy')
24.7.3.TO_DATE('1-1-1998','mm-dd-yyyy')
24.7.4.TO_DATE('Jan 1, 2000','mon dd, yyyy')
24.7.5.Using TO_DATE Within PL/SQL: TO_DATE('031092','MMDDYY')