I have a SQL table with two columns (StartDate & EndDate) with these records:

```
StartDate                     EndDate
2019-03-21 02:00:00.0000000   2019-03-23 04:00:00.0000000
2019-03-22 02:00:00.0000000   2019-03-23 05:00:00.0000000
2019-03-22 07:00:00.0000000   2019-03-22 12:00:00.0000000
2019-03-22 01:00:00.0000000   2019-03-23 04:00:00.0000000

```

I also receive from my application two custom dates:

start\_date = '2019-03-22 00:00:00'

end\_date = '2019-03-22 23:59:59'

I have already tried with the following query, but it's not returning all the records that fit:

```
select * from [dbo].[Bookings]
where (StartDate <= '2019-03-22 00:00:00' AND EndDate >= '2019-03-22 23:59:59')
OR (StartDate >= '2019-03-22 00:00:00' AND EndDate <= '2019-03-22 23:59:59')

```

I want to return all records that fit (or are inside) this received time period, which in this case, should be all.