mysql - 从我的表格中选择日期 = 特定日期

Question

我在表中的日期是 TIMESTAMP 类似这样的 2016-05-28 18:39:00

现在我尝试从表中选择日期 = 2016-05-28

这是我的问题

    $getReport = $db->prepare('SELECT a.proId, a.userId, DATE(a.date), a.status, a.canceledBy, b.id, b.pName, b.pPrice FROM purchaseshistory AS a INNER JOIN products AS b ON(a.proId=b.id) WHERE a.date=?');

    $getReport->bind_param('i', $dateOfBirth);
    $getReport->execute();
    $getReport->bind_result($proId, $userId, $date, $status, $canceledBy, $id, $pName, $pPrice);
$getReport->store_result();
while ($getReport->fetch()) {

日期来自这里

$dateOfBirth = $_POST['dateOfBirth'];

结果为空

Answer 1

你可能需要一个正确的日期格式

SELECT a.proId, a.userId, 
DATE(a.date), a.status, a.canceledBy, b.id, b.pName, b.pPrice 
FROM purchaseshistory AS a 
INNER JOIN products AS b ON(a.proId=b.id) 
WHERE date_format(a.date,'%Y-%m-%d') = ?