Re: view puzzle
From: Vladimir Andreev <flado_at_imail.de>
Date: 18 Jan 2004 06:26:28 -0800
Message-ID: <7b208869.0401180626.26d1197b_at_posting.google.com>
Date: 18 Jan 2004 06:26:28 -0800
Message-ID: <7b208869.0401180626.26d1197b_at_posting.google.com>
> Restricting to the date is pretty simple when it's there. It's
> just a select statement that has start_date <= working_date
> and end_date >= working_date. But how do I procede when there
> is no working date?
What's wrong with:
where working_date is null or working_date between start_date and end_date
Or with this:
where nvl(working_date,start_date) between start_date and end_date
Of course, I assume start_date and end_date cannot be NULL...
HTH
Flado
Received on Sun Jan 18 2004 - 15:26:28 CET