Discard a row in sql time

Question

How do we insert a string into a time type with mysql in java So the string is -------> java.sql.time

thank.

Answer 1

It completely depends on the format of yours String, so I would use SimpleDateFormatto parse the string in java.util.Date; then you can extract the millisecond time value from this date and pass it to java.sql.Time(). Like this:

String s = /* your date string here */;
SimpleDateFormat sdf = new SimpleDateFormat(/* your date format string here */);
long ms = sdf.parse(s).getTime();
Time t = new Time(ms);

Answer 2

java.sql.Time.valueOf("String");

Answer 3

:

java.sql.Time.parse("String");

DateFormat Parse http://java.sun.com/j2se/1.4.2/docs/api/java/text/DateFormat.html