i want to fetch data from database between two dates.
startdate and end_date are like (2018-04-04) and database column name datetime has a value date and time like (2018-04-04 12:05:07).
Both dates(startdate and end_date ) check with datetime column in database.
i am using query (select * from table where datetime>=startdate and datetime<=end_date). if i select both dates same like(2018-04-04 and 2018-04-04) then this query is not working. please help me how to do this?