Java 中时间转换

Since java.sql.Timestamp is inherite from java.util.Date, so simply doing this will do:

SimpleDateFormat ft = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
java.sql.Timestamp ts = new java.sql.Timestamp(System.currentTimeMillis());
System.out.println(ft.format(ts));

 

Suppose your TIMESTAMP variable is a string, then you could do:

String timeStampStr = "2003-08-23 02:14:38:371";
SimpleDateFormat sdfIn = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
SimpleDateFormat sdfOut = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");        
Date date = sdfIn.parse(timeStampStr);
String timeStrOut = sdfOut.format(date);
System.out.println(timeStrOut);