Checking if a Date falls within a Range of Dates in SQLITE

I have an sqlite table with with 2 date columns (beginning & end). I am looking for a query that returns the date range a date falls in. e.g Checking range where 10-02-2016 falls given 2 records as follows

(01-02-2016  -  12-02-2016) & (13-02-2016  -  20-02-2016)

Clearly it falls in the first range but how do I do it in SQLITE. Please help?