Date Format Error

[Rohit]

Hi all,

I am using Visual Basic to Access an Oracle Database. I am using Oracle OLEDB Provider fro connectivity.
The Table "Test" Looks like

No Number(3)
Do Date

I issue the following command in Visual Basic
De.con.execute "Insert into test Values(" & text1.text &",'" & text2.text &')"

Value in text2= "12-dec-2002"
Debug.print returns "Insert into test values(10,'12-dec-2002')"
This works fine if i paste the above sql in Sqlplus but when executed from Visual basic the date is stored as "20-dec-0012" .

Is there a problem with the driver ? Please Do advice

Thanks

[pando]

I dont know why because I dont do VB stuffs, although myself I dont program a lot I do recommend you whenever you insert a date you should use to_date function to avoid implicit conversions since date format can vary from machine to machine (depending how´s your registry is defined)

[Rohit]

Thank you So much. Its Working Fine.
Yesterday i tried to_date , but my stupidity i wrote the format in double quotes. Now itw working fine . Thanks .