Dates validation

From: Nico Vandenbroucke <nbroucke_at_be.oracle.com>
Date: 1997/03/12
Message-ID: <5h8uaq$au1@inet-nntp-gw-1.us.oracle.com>#1/1

We have an application in which many tables have date range columns (start and end date).

We have to check a lot if a certain date falls within the date range, or if two date ranges are not overlapping or if a date range falls within another.

This means a lot of ' date_x between start_dt and end_dt 'stuff in the SQL statements.

Does any1 know of a (brilliant) way to avoid or minimise all this checking?

regards
Nico Received on Wed Mar 12 1997 - 00:00:00 CST