获取上周三到本周三的数据，格式化时间sql

获取上周三到本周三的数据，格式化时间sql

获取上周三到本周三的数据

SELECT * FROM table a WHERE 
a.time >= (SELECT DATE_FORMAT( SUBDATE(CURDATE(), WEEKDAY(CURDATE()) + 5), '%Y-%m-%d 12:00:00'))
AND a.time <= (SELECT DATE_FORMAT( SUBDATE(CURDATE(), WEEKDAY(CURDATE()) - 2), '%Y-%m-%d 12:00:00'));

(SELECT DATE_FORMAT( SUBDATE(CURDATE(), WEEKDAY(CURDATE()) + 5), '%Y-%m-%d 12:00:00')) AS '上周三';
(SELECT DATE_FORMAT( SUBDATE(CURDATE(), WEEKDAY(CURDATE()) - 2), '%Y-%m-%d 12:00:00')) AS '本周三';

select SUBDATE(subdate(curdate(),date_format(curdate(),'%w') - 1),5)  AS '上周三不带时间';
select SUBDATE(subdate(curdate(),date_format(now(),'%w') - 1),-2)  AS '本周三不带时间';

格式化时间

比如：
SELECT 
DATE_FORMAT(a.time,'%Y-%m-%d %h:%m:%s') AS '时间'
FROM table a WHERE 
---------------------------------------
DATE_FORMAT(a.time,'%Y-%m-%d %h:%m:%s')