MySQL query to search in between two time range between two dates using timestamp data -

i have timestamp values in db. has values 2014-11-25 10:30:00. need records between 2 dates , has time between range between 2014-10-20 2014-11-25 , between 9am 7pm..

i need query this...

you can use internal mysql functions convert datetype.

i think need date() , time() functions.

details can find here