date format

[puruji]

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_ACTIVATION_SWI TCH,Application,TARIFF,user_name,machineip,machine time) values('" & rs.Fields(1) & "','" & rs.Fields(2) & "','" & rs.Fields(8) & "','" & rs.Fields(9) & "', '" & rs.Fields(10) & "','" & MainForm.susername & "','" & MainForm.LocalInf & "','" & MainForm.EntryDateTime & "'
for third field date i have done using '" & rs.Fields(8) & "' :this is field from excel
? change need to done....using VB code......i have use adodb connection

[debasisdas]

use oracle conversion Function TO_DATE

[Killer42]

use oracle conversion Function TO_DATE

Another option is to use the VBA Format() function to format the value the way you want, before you put it in the string.

[Mayur2007]

Hi,

Try this in vb6.0
Format(Date, "dd/mm/yyyy")
or
Format(Date, "dd-mm-yyyy")

its for system date.

that might be helpful for u.

Mayur