mysql datetime类型大于,MySQL Where DateTime大于今天

I want to get evry record from my MySQL database wich is greater than today.

Sample:

"Go to Lunch","2014-05-08 12-00-00"

"Go to Bed","2014-05-08 23-00-00"

Output should only:

"Go to Bed","2014-05-08 23-00-00"

I use the DateTime for the Date Column

Already searched:

But this does not work for me.

QUERY(FOR PHP):

SELECT `name`,`date` FROM `tasks` WHERE `tasks`.`datum` >= DATE(NOW())

OR (FOR PhpMyAdmin)

SELECT `name`,`date` FROM `tasks` WHERE `tasks`.`datum` >= 2014-05-18 15-00-00;

Please help me to write the working Query.

解决方案

Remove the date() part

SELECT name, datum

FROM tasks

WHERE datum >= NOW()

and if you use a specific date, don't forget the quotes around it and use the proper format with :

SELECT name, datum

FROM tasks

WHERE datum >= '2014-05-18 15:00:00'