[SOLVED] How to get results for current date

[t_machine]

hi, I have a table that stores dates with the mysql CURRENT_TIMESTAMP. This stores each entry with the format (2008-11-12 00:11:08).

The problem I am having is getting the results for the current date. The following query will explain what I mean.

 

$sql = "SELECT * FROM my_table WHERE date_field = CURDATE()";

 

This does not give any results even though the current date is the same as a few records in the database. Any help would be greatly appreciated.

 

Thanks:)

[zenag]

SELECT DATE_FORMAT( date_field, '%Y-%m-%d' )
FROM `my_table`
WHERE date_field = CURDATE( )

[t_machine]

Thank you very much, works perfectly