Zarri Zarri - 3 months ago 10
SQL Question

Access data from database between two dates using sql

I want to access data from database between two dates, Date format is yyyy/mm/dd.I tried a lot of queries but not succeed.
Please help me out...Thanks!

Answer

Try following query to get data between the range:

SELECT  *
FROM    Table_Name
WHERE   From_date >= '2016-08-01' AND
        To_date   <= '2016-08-30'