SELECT * from img_panorama where device_id = 1035700 and DATEDIFF(start_time, '2018-05-15 10:04:27') % 3 =0 ORDER BY start_time
-- '% 3' 指定天数
mysql 取日期间隔,每隔某天数数据
于 2021-08-10 18:01:35 首次发布
SELECT * from img_panorama where device_id = 1035700 and DATEDIFF(start_time, '2018-05-15 10:04:27') % 3 =0 ORDER BY start_time
-- '% 3' 指定天数