while importing date field from excel to oracle using VB6 i got a problem in date format....they do no match...in excel it gives date in format mm/dd/yy but in oracle i need dd-mm-yyyy so? to do.
insert into tbl_cboss_data( mobileno,client ,DATE_ACTIVATIO N_SWITCH,Applic ation,TARIFF,us er_name,machine ip,machinetime) values('" & rs.Fields(1) & "','" & rs.Fields(2) & "','" & rs.Fields(8) & "','"...