String to Timestamp conversion

[amit prajapati]

Hi,

I am facing problem in converting String to Time stamp.

String MessageTime = null;
MssageTime = pPortOrderVO.getMLastUpdateTime();

//UPDATE DB
updStmt = vSqlConnection.prepareStatement(SQL_UPDATE_MPG_ORDERS);
updStmt.setTimestamp(3,vMessageTime);  // Error :The method setTimestamp(int, Timestamp) in the type PreparedStatement is not applicable for the arguments (int, String)

How can i convert into Timestamp from String object when i Update the DB ?

Regards,
Amit P.

[Jeanne Boyarsky]

You can use SimpleDateFormat in Java to build a Date object (which parses your string) and then convert that to a Timestamp.

[steve davis]

Use a SimpleDateFormat with an appropriate format string (be careful to use the correct format letters, uppercase and lowercase have different meanings!).