select to_char(to_date('1/10/2011','mm/dd/yyyy'),'mm-dd-yyyy') from dual