msyql

1.日期相关

//查询某一天
SELECT 。。。
 WHERE ( DATEDIFF ( ro.end_time, '2021-04-08' ) = 0 ) AND ro.rider_id = '8001' AND ro.state = 2;
 或者
  SELECT * FROM details_configuration dc WHERE DATE_FORMAT(dc.create_time,'%Y-%m-%d')='2021-04-29'
  或者
  SELECT * FROM tz_rider r WHERE YEAR(update_time)='2021' AND MONTH(update_time)='04' AND DAY(update_time)='02'
 //时间区间查询
 SELECT td.`create_time`,td.`type`
 FROM tentation_data td
 WHERE td.`create_time` BETWEEN '2021-05-01' AND '2021-05-03'
//查询某一月
 SELECT。。。
 WHERE ( DATE_FORMAT( ro.end_time, '%Y-%m' ) = '2021-04' ) AND ro.rider_id = '8001' AND ro.state = 2;
 ## 近似搜索，查询数据相近的一条
 SELECT *
 FROM time_setting  WHERE distance_travelled IS NOT NULL ORDER BY ABS(109 - `distance_travelled`)
 LIMIT 1;