MySQL 查询过去一周数据：从上周五到上周六
SELECT * FROM wjx_pg_time WHERE data_time >= DATE_TRUNC('WEEK',CURRENT_DATE()) - INTERVAL 1 WEEK - INTERVAL 1 DAY AND data_time < DATE_TRUNC('WEEK',CURRENT_DATE()) - INTERVAL 1 DAY
原文地址: https://www.cveoy.top/t/topic/o6sz 著作权归作者所有。请勿转载和采集!