The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time. Tom Cargill
The to_date function convert the string format date to the date format. When the developer want fetch the date format from the string, they can use to_date function. The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. The sysdate returns the current date from the oracle database server.
select to_date('2013/12/10', 'yyyy/mm/dd') from dual;