Want to WHERE just the date in a DATETIME data type.
Posted: Wed May 03, 2006 1:57 pm
I have a sql query and I want to grab all the records in a table by the date. The problem is that the field with the date in it also has a time in it. It is a DATETIME data type.
Anyway ideas?
Matt
You can probably move this to the database section, just thought that I might have to format in PHP first before putting it in the SQL query.
Anyway ideas?
Matt
You can probably move this to the database section, just thought that I might have to format in PHP first before putting it in the SQL query.