I have a record with a datetime field in (it is for appointment dates and times).
I however want to be able to query the table to find all appointments for that particular day, but the database doesnt seem to return any results unless I specify the time as well.
For example, a record has the appointment set to '2004-06-25 20:30:00'
and if I query SELECT * FROM leads WHERE appointment='2004-06-25' nothing is returned.
Can anyone help me?