获取本周周三对应的日期:
select subdate(curdate(),date_format(curdate(),'%w')-3) as '本周三对应日期'
获取对应日期是周几:
SELECT date_format('2017-04-19','%w');
获取前一天和后一天的日期:
SELECT SUBDATE(NOW( ), 1) AS 'Yesterday', SUBDATE(NOW( ), INTERVAL -1 DAY) AS 'Tomorrow';
获取本周周三对应的日期:
select subdate(curdate(),date_format(curdate(),'%w')-3) as '本周三对应日期'
获取对应日期是周几:
SELECT date_format('2017-04-19','%w');
获取前一天和后一天的日期:
SELECT SUBDATE(NOW( ), 1) AS 'Yesterday', SUBDATE(NOW( ), INTERVAL -1 DAY) AS 'Tomorrow';