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_ACTIVATIO N_SWITCH,Applic ation,TARIFF,us er_name,machine ip,machinetime) values('" & rs.Fields(1) & "','" & rs.Fields(2) & "','" & rs.Fields(8) & "','" & rs.Fields(9) & "', '" & rs.Fields(10) & "','" & MainForm.susern ame & "','" & MainForm.LocalI nf & "','" & MainForm.EntryD ateTime & "'
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