Oracle - Overlaps function


/ Published in: SQL
Save to your folder(s)

This function can be used to find out if there exists an overlap between two pairs of dates or time.

There is an alternate way to calculate the actual overlapping value - Read the snippet "How to avoid double counts"

URL: http://oraclesponge.wordpress.com/2008/06/12/the-overlaps-predicate/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.