MySQL数据库查询时间段的两种方法:
1.
SELECT* FROMgroup_details model WHEREmodel.create_time BETWEEN TO_DAYS ( '-10-23 14:42:04' ) AND TO_DAYS ( '-10-26 10:41:35' ) ORDER BYmodel.create_time DESC
SELECT* FROMgroup_details model WHEREmodel.create_time BETWEEN '-10-24 14:42:04' AND '-10-25 10:41:35' ORDER BYmodel.create_time DESC
或者
SELECT* FROMgroup_details model WHEREmodel.create_time > '-10-24 14:42:04' AND model.create_time < '-10-25 10:41:35' ORDER BYmodel.create_time DESC
但是between and 包含时间界限,也相当于>= <=,而> <不包含
SELECT* FROMgroup_details model WHEREmodel.group_name LIKE '%试10257%' AND model.user_pid = 'f9aa7a315c1d0a1c1f2e549f0001' AND model.create_time BETWEEN '-10-24 14:42:04' AND '-10-25 10:41:35' ORDER BYmodel.create_time DESC
SELECTmodel.user_pid,usr.pid FROMgroup_details_user modelLEFT JOIN user_info usr ON model.user_pid = usr.pidLEFT JOIN group_details details ON model.group_details_pid = details.pid _pid = 'f9aa7a31676f68d40167866d89e703d1'AND details.pid <>'8a80cb816dfc7f16016dfc8034c10003'AND usr.user_title LIKE ''
/*** 分页显示分组** @param title* @param uid* @param startTime* @param endTime* @param pageable* @return*/@Query(value = "SELECT \n" +"model\n" +"FROM CourseType model \n" +"WHERE model.groupName like ?1\n" +"And model.userPid = ?2 \n" +"And model.createTime \n" +"BETWEEN ?3 And ?4 \n" +"order by model.createTime DESC ",nativeQuery = true)Page<GroupDetails> findAllByPage(String uid, String title, LocalDateTime startTime,LocalDateTime endTime, Pageable pageable);