[yymae]

Hi,

I'm having a problem here. Suppose a date is in String format from the user selected, like "31/12/2003" (dd/MM/yyyy). I want to format it into date to this format (MM/dd/yyyy). And there will be a time in String format pass in from the form, like "3:00 PM"

Both date and time are separated String field, but when inserting into database I need to combine it into date format, like "12/31/2003 3:00 PM"

How to do it ? Please give some examples on this ASAP.

Thanks.

Cheers,
yymae

[stdunbar]

Take a look at http://java.sun.com/j2se/1.4.2/docs/...ateFormat.html

To parse I would do something like:

String dateAndTime = userDateInput + " " + userTimeInput; // i.e. "31/12/2003 3:00PM"

SimpleDateFormat dateFormatter = new SimpleDateFormat( "dd/MM/yy kk:mm aa");

Date theDate = dateFormatter.parse( dateAndTime, new ParsePosition() );

...

// assume that the prepared statment is setup in some way

...
preparedStatement.setTimestamp( fieldNumber, new java.sql.Timestamp( theDate.getTime() ) );

// use timestamp if you want to remember the time component across multiple
// databases. setDate() truncates the time with some JDBC drivers.