数据库的时间字段是int型的,例如:1143248298
是以秒为单位
而
Timestamp unixTime = new Timestamp(参数);
是以毫秒为单位的
你这么做就好了
Timestamp unixTime = new Timestamp(1143248298000L);
.//Convert Unix timestamp to normal date style
.public String TimeStamp2Date(String timestampString){
. Long timestamp = Long.parseLong(timestampString)*1000;
. String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(timestamp));
. return date;
.}
当调用TimeStamp2Date("1252639886");
返回值:11/09/2009 11:31:26