SLQ get all the data in a time period

Condition: According to the data of a time period of the database, get all the data information during the filter period:

By analyzing the data in this filter time period can be broadly divided into the following 3 cases:

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

2. The end time of a field in a database is within the filtered start and end time range

3. The start time of a field in a database is less than the filtered start time and the end time is greater than the filtered end time

The conversion to SQL statement is:

((StartDate between ' filter start time ' and ' Filter End Time ') or (endDate between ' filter start time ' and ' Filter End Time ') or (StartDate <= ' filter start time ' and EN Ddate >= ' filter End Time ')

）

This article is from the "11457131" blog, please be sure to keep this source http://11467131.blog.51cto.com/11457131/1763936

SLQ get all the data in a time period