你是比较是不是在当前时间的15天内吗?
Timestatmp ts = new Timestamp(System.currentTimeMillis() - 24l * 3600 * 1000 * dayBefore);
用PreparedStatement prep = conn.preppareStatement("select * from table where createdate >= ?");
prep.setTimestamp(1,ts);
ResultSet rs = prep.executeQuery();
Timestatmp ts = new Timestamp(System.currentTimeMillis() - 24l * 3600 * 1000 * dayBefore);
用PreparedStatement prep = conn.preppareStatement("select * from table where createdate >= ?");
prep.setTimestamp(1,ts);
ResultSet rs = prep.executeQuery();
SELECT something FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(date_old) <= 30;
要省的查~也就是更通用的就是吧时间都变为秒~~再做差~当判断条件~