79714500

Date: 2025-07-25 09:30:49
Score: 1
Natty:
Report link

In our company we have found a good replacement for OVERLAPS and without OR operators to avoid using brackets.

If case of two periods start1-end1 and start2-end2 the result well be:

AND start1 <= end2
AND start2 <= end1

This construction works with any size of periods and don't need to use brackets and BETWEEN operand.

Reasons:
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: WinterMute