Hello,
In my table i have a datetime field...eg
Y-m-d H:i:s
And i want to do a query to bring out all records on todays date.
So how do i perform a check to match todays date('Y-m-d') with just the date part from the table?
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
there's a function called DATE_FORMAT
DATE_FORMAT('%Y%m%d', columnname) = DATE_FORMAT('%Y%m%d', NOW())
