i think this statement was work properly
select to_char(to_date(indate,'dd-mon-yyyy HH24:MI'),'dd/mm/yyyy') from tem1;
thank you
Type: Posts; User: arunkumark1407; Keyword(s):
i think this statement was work properly
select to_char(to_date(indate,'dd-mon-yyyy HH24:MI'),'dd/mm/yyyy') from tem1;
thank you