Dates validation
From: Nico Vandenbroucke <nbroucke_at_be.oracle.com>
Date: 1997/03/12
Message-ID: <5h8ubk$au1_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1997/03/12
Message-ID: <5h8ubk$au1_at_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 CET