You would do something similar to
select * from EVENTS where scheduled_start>'08/01/2000' and
scheduled_start<'08/31/2000
James Thompson
>From: Jeff Connor <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Quick SQL syntax question
>Date: Wed, 4 Oct 2000 10:16:48 -0400
>
>Can anyone tell me the equivalent SQL command to:
>
> Q EV * * begind=-1 begint=17:00 endd=today endt=08:00
>
>I'm struggling with the date/time range calculation.
>
>Thanks,
>Jeff Connor
>Niagara Mohawk Power Corp.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
