Shulou(Shulou.com)06/01 Report--

Condition: Obtain all data information within the screening time period according to the original data of a certain time period in the database:

By analyzing the data in this screening period, it can be roughly divided into the following three situations:

The start time of a field in the database is within the range of the start time and end time of the filter

The end time of a field in the database is within the range of the start time and end time of the filter

A database field has a start time less than the start time of the filter and an end time greater than the end time of the filter

Converted to SQL statement:

((startDate between 'Screening Start Time' and 'Screening End Time') or (endDate between ' Screening Start Time ' and ' Screening End Time') or (startDate ='Screening End Time')

）

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.