datetime mySQL SELECT only date

advertisements

I have a table in the mySQL DB that is set up with datetime.

I need to SELECT in this table only by DATE and excluding the time.

How do I SELECT in this table by only date and bypassing the time, even if that specific column is set to datetime?

Example:

Now it is: 2012-01-23 09:24:41

I need to do a SELECT only for this 2012-01-23


select date(ColumnName) from tablename

more on mysql date()