how to get data between two same dates when datefield is DATETIME

Hi friends

How to get data  between two same dates my query is working for timestamp 00:00:00

below is my query

SELECT ACTIVITY_TYPE,,date_format(ACTIVITY_DATE,'%Y/%m/%d') as logdate FROM activity_log WHERE ACTIVITY_DATE BETWEEN STR_TO_DATE('10/12/2010','%d/%m/%Y') and  STR_TO_DATE('10/12/2010,'%d/%m/%Y')

values in table

type  date

a        10/12/2010 11:39:43

b        10/12/2010 13:39:43

c        10/12/2010 14:39:43

my above query will work and returns these 3 rows  wen data is like this

a        10/12/2010 00:00:00

b        10/12/2010 00:00:00

c        10/12/2010 00:00:00

but when time is there how to fetch data

any ideas

thanks

sunil

You need to just use the date part of ACTIVITY_DATE -

... WHERE DATE(ACTIVITY_DATE) BETWEEN ...

thank u sir, it solved my problem