判断两个时间段是否有交集算法


declare
@inputStartDate datetime = '2017-02-01',
@inputEndDate datetime = '2017-04-20'

endDate>=@inputStartDate and BeginDate<=@inputEndDate

posted @ 2016-11-16 15:50  ThirteenYi  阅读(3130)  评论(1编辑  收藏  举报