selecting records matching a date in a datetime field

[JamieJelly]

Hi all,
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?

[swampBoogie]

SELECT * 
FROM leads 
WHERE appointment between '2004-06-25 00:00:00' and '2004-06-25 23:59:59'

[kamm]

You may find this useful as well...

SELECT * 
FROM `leads` 
WHERE appointment BETWEEN SUBDATE(NOW(),INTERVAL 1 DAY) AND NOW()

http://dev.mysql.com/doc/mysql/en/Da...functions.html

hasta later,
kamm...

[r937]

kamm, how is that useful? those are appointments
within the last 24 hours -- some from yesterday, some from today

[kamm]

Yeah you're right (again) - it's not gonna help in this situation...

Oh oh --> off to the back of class again... (they don't have smilies with dunces hats)

hasta later,
kamm...

[JamieJelly]

thanks very much guys, the "between" method came to me in my sleep. Honest it did....