mysql where date equals today code example

Example 1: mysql date equals to current_date plus days

SELECT CURRENT_DATE - INTERVAL 30 DAY

Example 2: mysql check datetime equals date

SELECT * FROM `calendar` WHERE DATE(startTime) = '2010-04-29'