今天查询用到了时间段比较
离现在最近的时间 ,用于查询最近一条记录
select record_value from record where(currenttime in (select max(currenttime) from record)) and sensor_id='297e3cf136330a820136330b89e20008'
数据库时间存储,存入yyyyMMddHHmmss的String
/**
* 将date转为 yyyyMMddHHmmss
* auther liuwei
* @param Date
* @return String
*/
public static String changeDateToYmdhms2(Date d) {
if (d == null)
return "";
else{
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
String t = sdf.format(d);
return t;
}
}