How can I select all rows that have a specific date between start_date and end_date, let's say a month?

Question

SQL

How can I select all rows that have a specific date between start_date and end_date, let's say a month?
The overall task is to select everything that was active in a certain month of a certain year somehow.
I hope I wrote clearly.

Answer 1

select * from my_table where <Определенная дата> between start_date and end_date