select data from database between two dates where date datatype is datetime

select * from [tablename] where [datefrom] between [dateto]

select * from [tablename] where convert(datetime,[datefrom],103)>'"+[valuefrom]+"' and convert(datetime,[dateto],103)<'"+[valueto]+"'

WHERE ((CAST(FLOOR(CAST(SearchDate AS FLOAT)) AS DATETIME) 
	BETWEEN 
	CAST(FLOOR(CAST(@FromDate AS FLOAT)) AS DATETIME)
	AND CAST(FLOOR(CAST(@ToDate AS FLOAT)) AS DATETIME))

SELECT * FROM TableName where datetime between
to_date('01-oct-2012,'mm/dd/yyyy') and
to_date('30-oct-2012','mm/dd/yyy')
order by datetime DESC;

select column1, column2 from tablename where
convert(char(20),columnname,105) between '21-10-2012' and '19-10-2012';

select * from `tablename` where `datetime` >= '2012-01-01 00:00:00' and `datetime` <= '2012-12-31 23:59:59';