I want to get every record from my MySQL database which 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;
How can I 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'
I guess you looking for CURDATE()
or NOW()
.
SELECT name, datum FROM tasks WHERE datum >= CURDATE()
LooK the rsult of NOW and CURDATE
NOW() CURDATE() 2008-11-11 12:45:34 2008-11-11
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With