Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Where DateTime is greater than today

Tags:

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:

  • MySQL Where date is greater than one month?
  • Datetime equal or greater than today in MySQL

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?

like image 604
RobDev Avatar asked May 18 '14 13:05

RobDev


2 Answers

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' 
like image 128
juergen d Avatar answered Oct 04 '22 21:10

juergen d


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        
like image 24
echo_Me Avatar answered Oct 04 '22 22:10

echo_Me