select from wjx_pg_time where data_time = date_truncweekcurrent_date - interval 1 week -interval 1 day and data_time date_truncweekcurrent_date -interval 1 day转成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
原文地址: http://www.cveoy.top/t/topic/hDI3 著作权归作者所有。请勿转载和采集!