SQL & PL/SQL

Hi,

i have date data from DB coming in the format dd-mon-yyyy but i want convert this to mm/dd/yyyy in my query and display in the apex region using htp.p(.......)  ie. no option for apex report format,

i tried something like

select  to_date( to_char(created_date,  'dd-mon-yyyy'), 'mm/dd/yyyy') FROM emp where  rownum <= 2;   but i always get the error not a valid month....

( also i dont want to do this by altering DB session so ive to do it in the query only)

any idea is appreciated,

regards