I have a table that contains a table with the following column

date datetime 0000-00-00 00:00:00
I need to run the following queries, however, I'm unsure about what to point in the where portion of the statement.

SELECT COUNT(*) FROM table where date = today's date;
SELECT COUNT(*) FROM table where date = this month
SELECT COUNT(*) FROM table where date = last month


I'm unsure how to connect today's date, month, and last month to the format 0000-00-00 00:00:00 to get a count.

Any suggestions?