MySQL compare now only date not time with a datetime field

Question

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

User · Accepted Answer

Use DATE NOW    to compare dates  DATE NOW    will give you the date part of current date and DATE duedate  will give you the date part of the due date  then you can easily compare the dates  So you can compare it like   DATE NOW      DATE duedate    OR   DATE duedate    CURDATE      See here

User · Answer

Compare date only instead of date   time  NOW  with   CURDATE

[mysql] MySQL compare now() (only date, not time) with a datetime field

Examples related to mysql