Check if the date is up or past in MysQL

Question

I have two columns in a table

• event_date (value - 09/22/2013)
• event_time (value is 7:11 PM)

Now I want to write a query that should return a string that has a time and date in the future or past

I wrote something like this

select * from events e where concat(e.event_date,' ',e.event_time) <= date_format(now(),'%m/%d/%Y %g:%i %a') 

But he did not work, this is only one of those things that you never know what is wrong with them.

Thanks in advance!

Answer 1

 SELECT * FROM Events WHERE event_date < CURRENT_DATE() OR ( event_date = CURRENT_DATE() AND event_time <= CURRENT_TIME() ) 

This has the advantage of using any index that may exist on event_date .

Answer 2

 select * from events e where TIMESTAMP(e.event_date,e.event_time) <= NOW() 

Answer 3

Possible solution if event_date and event_time values ​​are saved as you showed them

Select past events

 SELECT * FROM events WHERE STR_TO_DATE(CONCAT(event_date, ' ', event_time), '%m/%d/%Y %h:%i %p') < NOW() 

Choose future events

 SELECT * FROM events WHERE STR_TO_DATE(CONCAT(event_date, ' ', event_time), '%m/%d/%Y %h:%i %p') > NOW() 

Here is the SQLFiddle demo