Need date conversion code to excel
Hi All,
i have data like
----------------------------------
select '23-MAY-12' FROM DUAL
UNION
SELECT '24-MAY-12 FROM DUAL;
-----------------------------------------------
My Requirement
1)i have convert d the DD/MM/YYYY formate. using
select TO_CHAR( '23-MAY-12','DD/MM/YYYY') FROM DUAL
UNION
select TO_CHAR( '24-MAY-12','DD/MM/YYYY') FROM DUAL;
2)then i am trying export/download to excel this above date ..it is passing left side in excel as a text ...how to make once downloading from sqldev should have date format with right side.
Please help me out.