hi, this is a simple question, but yet i get confused all the time and i need clarification.
What like to know is what is the best way to convert a date value form (String--->Date).
The other problem is that i did use the [Date] object in accessing my database (MS Access) with this quere:
String quere = "SELECT * FROM Table WHERE Date BETWEEN '"+fromdate+"' AND '"+ todate+"'";
where, fromdate & todate are both [Date] objects, but with no results...
If any one can give me a model of how to use the [Date] object with the Database Date/Time fields.
i *think* as you are using MS Access the data values need to go between #'s
so BETWEEN #<fromdate>#
SimpleDateFormat can convert String to Date or convert date to string easyly..
if you use ms access ,the date param must be String(MM/dd/yyyy) adn
closed by '#' and '# '
For your query, use a PreparedStatement rather than a Statement object. You should also convert from java.util.Date to java.sql.Date:
// Convert dates
java.util.Date fromDate = ...
java.util.Date toDate = ...
java.sql.Date fromSQLDate = new java.sql.Date(fromDate.getTime());
java.sql.Date toSQLDate = new java.sql.Date(toDate.getTime());
// Use PreparedStatement
String sql = "SELECT * FROM Table WHERE Date BETWEEN ? AND ?"
PreparedStatement ps = connect.prepareStatement(sql);
ps.setDate(1, fromSQLDate); // Replaces first "?"
ps.setDate(2, toSQLDate); // Replaces second "?"
ResultSet results = ps.executeQuery();
One big advantage of a PreparedStatement is that it will automatically make the database-specific translations for your Date objects (and other SQL datatypes).