Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update a date field in SQL database

843854Oct 4 2001 — edited Oct 4 2001
I am using MS SQL 2000..and .Jdbc-odbc bridge

I have a field of type datetime...

I am trying to update that field value...using the following code

rs.updateDate(fieldname,java.sql.Date.valueOf(fval));
rs.updateRow();
where fVal is a string...

It gives me a SQl Exception saying invalid date value..

Can any throw any light on this...helping me to overcome my error...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2001
Added on Oct 4 2001
#java-database-connectivity-jdbc
1 comment
99 views