wood burning stoves 2.0*
The moose likes JDBC and the fly likes inserting a date in MS Access 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 "inserting a date in MS Access" Watch "inserting a date in MS Access" New topic

inserting a date in MS Access

anupama rc

Joined: Mar 01, 2001
Posts: 3
hi freinds
i am doing this servlet program where i have to insert dates into a data base...i accept the date as a string ...convert into Date object ...but when i try toinsert into the data base ...its giving me an error saying Syntax error (operator missing)..
I have converted the string into date object using SimpleDateFormat class...and its parse mtd
pls help


Joe Paolangeli
Ranch Hand

Joined: Apr 05, 2000
Posts: 73
When creating the date object for the insert try using java.sql.Date instead of java.util.Date
I agree. Here's the link: http://aspose.com/file-tools
subject: inserting a date in MS Access
Similar Threads
Runtime Exception
date format issue. can you please tell
java.text.ParseException in Web service
Assigning sub class reference to super class object
Difference in "? extends Object" and "Object" in Generics