Mega Code Archive
Categories
/
Oracle PLSQL Tutorial
/
Date Timestamp Functions
DBMS_OUTPUT PUT_LINE(TO_DATE (19991205))
SQL> SQL> BEGIN 2 3 DBMS_OUTPUT.PUT_LINE(TO_DATE ('19991205')); 4 5 END; 6 / END; * ERROR at line 5: ORA-01861: literal does not match format string ORA-06512: at line 3 SQL>