With a SQL statement, I want to find the entries for a single day.

**Consider the following entries:**

* Id 1, StartAt 2020-04-12 08:00:00.0000000, EndAt 2020-04-12 15:00:00.0000000
* Id 2, StartAt 2020-04-11 08:00:00.0000000, EndAt 2020-04-13 15:00:00.0000000

**When I want to find the entries for the day:**

* 2020-04-11, result should be: Id 2
* 2020-04-12, result should be: Id 1 and 2
* 2020-04-13, result should be: Id 2

I tried using different '<' '>' operators and the BETWEEN keyword, but couldn't get the right syntax, as it's a timeperiode I want to find, within another timeperiode.