时间返回时后面多了个.0,
时间返回的格式是:2017-07-0714:55:46.0
可以通过SQL语句来处理
DATE_FORMAT(beginTime,'%Y-%m-%d %H:%i:%s')
Solution:
java.sql.Date.valueOf(DateUtils.dateToString(obj.getDate("createTime"),"yyyy-MM-dd"))
/*
* Timestamp 转 Date
* */
public static Date convertToDate(Timestamp ts)
{
Date date = new Date();
date = ts;
return date;
}
/*
* Date 转 Timestamp
* */
public static Timestamp convertToTimestamp(Date date){
String time = "";
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
time = sdf.format(date);
return Timestamp.valueOf(time);
}
public static Timestamp converToBaseTs(Date date)
{
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Calendar cal = Calendar.getInstance();
cal.setTime(date);
int hour = cal.get(Calendar.HOUR_OF_DAY);
int minute = cal.get(Calendar.MINUTE);
int second = cal.get(Calendar.SECOND);
//时分秒(毫秒数)
long millisecond = hour*60*60*1000 + minute*60*1000 + second*1000;
cal.setTimeInMillis(cal.getTimeInMillis()-millisecond);
return convertToTimestamp(cal.getTime());
}
timestamp先转换为long类型,然后long类型再转换为DateTime