Getting date from datetime

[Anon]

I want to select all of the info from a table with todays date. The problem is that the records are stored as a datetime. Here is what I am trying to do.

Select count(id) from table where datestamp = cur_date();

Is there a way to strip the date out of the datestamp so it can be equal to the current date?? If the with the time in the datestamp it will never be equal. Any suggestions??

[Anon]

datetime handling are implemented dífferently in almost all DBMS.

[Anon]

Sorry, it is MySQL 3.X

[Anon]

There are numerous ways, e.g.

WHERE TO_DAYS(current_date) = TO_DAYS(datetimecolumn)

You could take a look at datetime functions in the documentation

[Anon]

Looks like it worked. Thanks a bunch!!!