converting the date/time fields into Strings

[sam davis]

Hello,
I have a field of date/time as a part of my sql statement to update the database. I want to convert that field into String and then, use that string in my SQL. This is wut im doing:
String m = (new SimpleDateFormat("EEE' 'yyyy-MM-dd' 'HH:mm:ss")).format((java.util.Date) start, new StringBuffer(), new FieldPosition(DateFormat.YEAR_FIELD)).toString();
Is this a right way of converting???..any suggestions or help would be greatly appreciated.

[Andy Bowes]

It is difficult to know whether what you are trying to do is correct without seeing the SQL statement.
I'd prefer to use a PreparedStatement rather than do all the datetime formatting that you are doing as I feel it is more readable.
i.e.

preparedStatement = conn.prepareStatement('update tablename set date_field = ? where ');
preparedStatement.setTimestamp( 1, new java.sql.Timestamp( theDate.getTime()));
preparedStatement.executeUpdate();

HTH

[sam davis]

hello,
my sql statement looks like this:
update = "UPDATE vippass SET start = \"" + m + "\", email=\"" + email + "\" WHERE passcode=\"" + passcode + "\"";

[Andy Bowes]

Hi Sam,
In that case I would rewrite your UPDATE statement as:

preparedStatement = conn.prepareStatement("UPDATE vippass SET start = ?, email=? WHERE passcode=?");
preparedStatement.setTimestamp( 1, new java.sql.Timestamp( start.getTime()));
preparedStatement.setString(2, email);
preparedStatement.setString(3, passcode);
preparedStatement.executeUpdate();

HTH