Date again

From: Rob Zwartjes <rzwartje_at_rob.home.nl>
Date: 2000/06/25
Message-ID: <slrn8lbti0.erb.rzwartje@rob.home.nl>#1/1

Hello there,

at the moment I have got something with date :). So I have 2 questions for you.
1: I want to search the table from the first date to a selected second date like:

	select * from MyTable
	where name like 'Rob'
	and datum between '01-jan-1999' and '01-sep-1999';

This goes smoothly, accept I didn't start at '01-jan-1999' but at '28-jan-1999'. Changing '01-jan-1999' into min(datum) oracle starts complaining. How can I overcome this problem.

2: I want to do a search from min(datum) to + 50 days. Where min(datum) will be the starting point for the next search for the next 50 days. Of course I can do the calculation myself :) But being lazy than tired and knowing that oracle can calculate max(datum) - min(datum) I expect that it can also calculate what the end date will be from the starting point.

Thanks in advance,
Rob Received on Sun Jun 25 2000 - 00:00:00 CDT