In software, we rarely have meaningful requirements. Even if we do, the only measure of success that matters is whether our solution solves the customerís shifting idea of what their problem is. Jeff Atwood
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;