如何比较日期在php与不同的格式Y/m/d和Y/m/d H: m存储在数据库中 - How can i Compare dates in php with different formats Y/m/d and Y/m/d H:M stored in a database?

How can i Compare dates in php with different formats Y/m/d and Y/m/d H:M stored in a database?

我有一个这样的查询:

$monitor = $db->query("SELECT * FROM event,  step WHERE step = idstep ");
$countquery = $monitor->rowCount();
if ($countquery == 0){
    echo "no records";
}else{
    echo "show records";

和我想成为:

$today = ("Y/m/d");
$monitor = $db->query("SELECT * FROM event,  step WHERE step = idstep AND datastep = $today");
$countquery = $monitor->rowCount();
if ($countquery == 0){
    echo "no records";
}else{
    echo "show records";

在我的数据库中，数据步存储为:Y/m/d H: m，当我比较2个日期时，我没有结果。我不想考虑小时和分钟。我如何比较日期，而不改变数据库中的字段数据步?我想把数据步转换成Y/m/d格式。

使用DateTime对象

$today = new DateTime("2014/07/31");

，你可以把它格式化成你喜欢的样子:

$today->format("Y/m/d H:M");

但是我认为你也可以在mysql中使用DATE():

SELECT * FROM event, step WHERE step = idstep AND DATE(datastep) = DATE('$today');

mysql中的DATE()函数将只返回天，这样DATE('2014/07/31 12:00')将等于DATE('2014/07/31')。