I have a duedate
column(datetime
format) that specifies the due date of a ticket, now i need to get 'Due today' tickets base on the comparison between now()
with duedate
. i.e 2010-04-29 02:00
vs 2010-04-29 10:00
would return true in this matter.
This question is related to
mysql
Compare date only instead of date + time (NOW) with:
CURDATE()
Source: Stackoverflow.com