timestape类型时间查询
String searchTime=“2019-08-15”;
Timestamp starTimestamp = Timestamp.valueOf(beginTime + " 00:00:00");
Timestamp endTimestamp = Timestamp.valueOf(beginTime + " 23:59:59");
sql:
select * from 表名 where send_date>=#{starTimestamp } and send_date<=#{endTimestamp };