This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Updating Date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Updating Date " Watch "Updating Date " New topic
Author

Updating Date

mujtaba habib
Greenhorn

Joined: Feb 26, 2001
Posts: 12
i want to update a date/time field in MS Access Database. here is the code but its not working
java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());

result.updateDate("op_pw_change_date",sqlDate);
result.updateRow();
Error Message is: Error in row
its works fine when i comment updateDate row
any idea ??
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
I don't think the JDBC-ODBC driver supports that method.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
mujtaba habib
Greenhorn

Joined: Feb 26, 2001
Posts: 12
hmm.. but other updateXXX() methods r working fine
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Updating Date
 
Similar Threads
preparedStatement.setDate and java.util.Date
util.Date to sql.Date
Converting From String to java.sql.Date
Passing java.sql.date to constructors
Save date to the database