❤️mysql查询7天前的日期

小明的学习圈子2023-08-13数据库MySQL

mysql查询7天前的日期

	SELECT *
	  FROM courseware_visit_history_info v
	WHERE v.COURSEWARE_VISIT_ID='000bf820b2574f8dabdc2bb1c7c63241'
	  AND v.VISIT_TIME
  BETWEEN date_sub(NOW(),interval 7 day) AND NOW()
Last Updated 2024/4/6 10:47:15