Find overlapping date in database

[Hilal]

I have entered the start and end date and now I want to find the number of days which overlap with the start and end date in my database. I am having difficulty finding a logic in python which will do this job. I am using Oracle database.

[Larz60+]

I think (Can't test) SELECT * FROM tablename WHERE TO_DATE('01/01/2021', 'MM/DD/YYYY') <= TO_DATE('12/16/2021', 'MM/DD/YYYY')
will do it, replace tablename with your tablename, and change dates to your requirement.

[Hilal]

I think (Can't test) SELECT * FROM tablename WHERE TO_DATE('01/01/2021', 'MM/DD/YYYY') <= TO_DATE('12/16/2021', 'MM/DD/YYYY')
will do it, replace tablename with your tablename, and change dates to your requirement.

Thanks a lot for your help, it worked.