Home:ALL Converter>Records between 2 dates Oracle SQL

Records between 2 dates Oracle SQL

Ask Time:2021-09-22T05:52:31         Author:simranjeet singh

Json Formatter

I am looking to filter out records between 2 dates. Here is a list of start and end dates. I need identify records that fall under the respective periods. I am able to identify the records that fall in the first and last period i.e. first (9/07/2020 - 22/07/2020) and last (10/11/2020 - 23/12/2020) by using MIN and MAX. I am not able to find records that fall in between i.e. 2-11?

enter image description here

I have another table that shows a date when the records were updated. For instance,

enter image description here

I need to identify the records that falls under what periods. For instance,

enter image description here

Any kind of help would be appreciated!

Thanks

Author:simranjeet singh,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/69275934/records-between-2-dates-oracle-sql
yy