MSSQL – preklapanje raspona datuma

Problem: Kako saznati da li se dva raspona datuma preklapaju?

raspon1 = 20.02.2013 – 01.03.2013

raspon2 = 15.01.2013 – 22.02.2013

Rješenje: 

(Start1 <= End2) AND (Start2 <= End1)

tj.

(20.02.2013<= 22.02.2013) AND (15.01.2013 <= 01.03.2013)

… da li se preklapaju i u početnim i završnim točkama

(Start1 < End2) AND (Start2 < End1)

… da li se preklapaju ne računajući početne i završne točke

This entry was posted on Saturday, March 30th, 2013 at 4:25 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.