一 . controller
<span style="white-space:pre"> </span> String 传成 Timestamp
SimpleDateFormat SDF_1 = new SimpleDateFormat("yyyy/MM/dd HH:mm");
Date pubTime = SDF_1.parse(timeString);
SimpleDateFormat sb2 = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String t2 = sb2.format(pubTime);
System.out.println("保存String pubTime "+t2);
Timestamp ts = Timestamp.valueOf(t2);
二 sql
1,检索时间段
/*%if startTime != null*/
and unix_timestamp(tb.publish_dat) >= unix_timestamp(/* startTime */'1955-04-28 00:00:00')
/*%end */
/*%if endTime != null*/
and unix_timestamp(tb.publish_dat) <=unix_timestamp(/* endTime */'2016-04-28 00:00:00')
/*%end */
2. 检索 几天内的
/*%if dade != 0*/
and
TO_DAYS(NOW()) -/*dade*/10 <= TO_DAYS(end_dat)
and
TO_DAYS(end_dat) <= TO_DAYS(NOW())
/*%end */
检索一年以内的
where inputtime>UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) 数据库时间为 时间戳格式
where inputtime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR) 数据库时间为 时间格式
3. 输出 特定格式时间
FROM_UNIXTIME( unix_timestamp(tb.publish_dat), '%Y-%m-%d %H:%i') as publish_da 数据库时间格式为DATETIME
FROM_UNIXTIME(tb.publish_dat, '%Y-%m-%d %H:%i') as publish_da 数据库时间格式为时间戳 integer
DATE_FORMAT(date, '%Y-%m-%d')=#{date}