sql这个星期的日期

SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-1)) as a UNION SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-2)) as a UNION SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-3)) as a UNION SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-4)) as a UNION SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-5)) as a UNION SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-6)) as a UNION SELECT DATE(subdate(curdate(),date_format(curdate(),'%w')-7)) as a