date from date in mysql code example
Example 1: get date from now() mysql
You can use CURDATE()
Example 2: mysql get date from datetime
WHERE DATE(datetime) = '2009-10-20'
You can use CURDATE()
WHERE DATE(datetime) = '2009-10-20'