how to select today's data

[scorpioy]

I have a table with column time, it has the format: 0000-00-00 00:00:00
I want to extract data which is only for today's.

I tried to use this condition in where clause

(now() < DATE_ADD(date_added, INTERVAL 1 DAY))

but nothing is displayed for today's data even through I do have the data, could some correct my sql query condition?

Thanks

[devinemke]

SELECT * FROM table WHERE DATE(date_added) = CURDATE()

[subwayman]

CURDATE() = DATE(date_added)

[scorpioy]

thanks guys, it works now

by the way, does CURDATE() on the left side or right side matter?