On Wed, 1999-09-01 12:12:56 +0200, Juergen Buddy Hoffmann wrote:
> How can I get records that match the entered date during a period? for
> event-name beginning end
> search&destroy 1999-05-27 1999-06-10
> Date entered in the search engine
> What is the correct select statement to retrieve the data?
WHERE '1999-05-30' BETWEEN beginning AND end;
> The user has the option to just enter the year, or year-month
> combination also.
What do you want to happen then? Select all events of this year?
Only select events that span completely that year? ...
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7