Date Format Error
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
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed