In a table indate and outdate are of varchar2 type. It stores data in the the format DD-MON-YYYY HH:MI (03-Apr-2006 16:48). While generating the report I need to display the date in the format DD/MM/YYYY. For that I have given the following command

select to_date(indate,'DD/MM/YYYY') , to_date(outdate,'DD/MM/YYYY') from cmswhitesugarweighment

It is showing errormessage

ORA-01858: a non-numeric character was found where a numeric was expected

Could anybody please suggest how to display date in DD/MM/YYYY format?

My table structure is

VEHICLENO VARCHAR2(50),
PRODUCT_CODE VARCHAR2(20),
PRODUCT_NAME VARCHAR2(50) ,
DELIVERYNOTE_NO VARCHAR2(50),
NO_OF_BAGS NUMBER,
DDNO VARCHAR2(70),
GROSSWEIGHT NUMBER,
TAREWEIGHT NUMBER,
NETWEIGHT NUMBER,
WEIGHNO VARCHAR2(50),
WEIGHMENT_DATE DATE,
INDATE VARCHAR2(50),
OUTDATE VARCHAR2(50),
SHIFTNO VARCHAR2(50),
CREATEDDATE DATE,
CREATEDBY VARCHAR2(50),
PARTYCODE VARCHAR2(50),
PARTYNAME VARCHAR2(50),
SEASONCODE VARCHAR2(10)