CODE EXAMPLE FOR SQL

date in where on datetime column clause mysql

You can use MySQL's DATE() function:

WHERE DATE(datetime) = '2009-10-20'
You could also try this:

WHERE datetime LIKE '2009-10-20%'