[Resolved] Extracting just the date from a datetime field

[Sparks]

Is the above possible? I want to extract all entires submitted today for example from a field containing 2004-02-25 01:02:53.

Running

SELECT * FROM " . $Table . " WHERE date_time_logged='" . date('Y-m-d') . "'";

obviously fails as I'm not giving it an entry for the time as well. I was going to pull up all the results, extract the time from the date_time_logged field, assign it to a variable and then run the comparison but this seems far too long winded especially when the database gets really big.

Thanks for your help.

[broc7]

Try WHERE date_time_logged LIKE '" . date('Y-m-d') . "%'";

[LordShryku]

http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#Date_and_time_functions
Look at date_format