Compare Two Different Date

SELECT * FROM `events` 
WHERE 
TO_SECONDS(`start_time`) >= TO_SECONDS('2012-10-27')
and TO_SECONDS(`start_time`) < TO_SECONDS('2013-2-1')

TO_SECONDS function is available after mysql 5.5

UNIX_TIMESTAMP('2012-12-21') could be a replacement

One thought on “Compare Two Different Date”

edward says:

03/22/2013 at 4:03 am

I need to to thank you for this very good read!! I certainly
loved every bit of it. I have you book marked to look at new stuff
you post…

Comments are closed.