php - 日期 pdo 之间的日期时间

Question

如何在 mysql 中获取每周数据？此代码对我不起作用。

 public function getWeeklyWinners() {
            $today = time();
            $a_week_ago = strtotime("-1 week");
            $sql = "SELECT * FROM money_transfer WHERE send_date BETWEEN ? AND ?";
            $query = $this->db->prepare($sql);
            $query->execute(array($today, $a_week_ago));
            if ($query->rowCount())
                return $query->fetchAll();
            return false;
        }

Answer 1

使用 date_sub 或 INTERVAL

SELECT * FROM money_transfer WHERE send_date 
BETWEEN date_sub(now(),INTERVAL 1 WEEK) and now();