在MySQL中Datetime等于或大于今天 - Code

下面最好的方法是什么:

SELECT * FROM users WHERE created >= today;

注意:created是一个datetime字段。

当前回答

SELECT * FROM users WHERE created >= NOW();

如果列是datetime类型。

2011-03-03 14:52:14

其他回答

您可以返回所有行，然后在if语句中使用PHP datediff函数，尽管这会给服务器带来额外的负载。

if(dateDiff(date("Y/m/d"), $row['date']) <=0 ){    
}else{    
echo " info here";    
}

2014-10-20 21:59:36

SELECT * FROM users WHERE created >= now()

2011-03-03 14:52:26

如果'created'是datetime类型

SELECT * FROM users WHERE created < DATE_ADD(CURDATE(), INTERVAL 1 DAY);

CURDATE()也表示“2013-05-09 00:00:00”

2013-05-09 08:29:09

SELECT * FROM myTable WHERE  DATE(myDate) = DATE(NOW())

阅读更多: http://www.tomjepson.co.uk/tutorials/36/mysql-select-where-date-today.html

2011-03-03 14:52:50

SELECT * FROM users WHERE created >= NOW();

如果列是datetime类型。

2011-03-03 14:52:14

aliyun