To_Date Function Examples

Example 1

PL/SQL queryResult
select to_date('2011/11/06', 'yyyy/mm/dd') from dual; 11/6/2011
select to_date('061111', 'MMDDYY') from dual; 6/11/2011
select to_date(sysdate, 'dd-mm-yyyy') from dual; 11/6/0011
select to_date('20100715', 'yyyymmdd') from dual; 7/15/2010