query for today .. and after

Article View: bit.listserv.sqlinfo

Article #249

Back to bit.listserv.sqlinfo Previous Next

#249

From: Diamondback
Date: Fri, 17 May 2002 19:38

13 lines
1665 bytes

I've got an event database that is starting out in Access, but eventually
will make its way to MySQL. My query (below) performs a simple find for all
upcoming events.  My problem is that it leaves out events occuring today.  I
need a query that will include events occuring for the current day, as well
as future events.  Can someone help here?

SELECT        event_id, event_name, event_date,
                       description, event_time, event_location,
                        city, state, contact, contact_email,
                       contact_phone
FROM            events
WHERE          event_date >= Now()
ORDER BY     event_date, event_name

Technical Details

Message-ID: <3%cF8.13668$ek5.8047@nwrddc02.gnilink.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed1.cidera.com!Cidera!cyclone1.gnilink.net!spamfinder.gnilink.net!nwrddc02.gnilink.net.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,e97c83419e3d415c,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 2002-05-17 12:38:41 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed1.cidera.com!Cidera!cyclone1.gnilink.net!spamfinder.gnilink.net!nwrddc02.gnilink.net.POSTED!53ab2750!not-for-mail
From: "Diamondback" <diamondback@hotmail.com>
Newsgroups: bit.listserv.sqlinfo
Subject: query for today .. and after
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <3%cF8.13668$ek5.8047@nwrddc02.gnilink.net>
Date: Fri, 17 May 2002 19:38:39 GMT
NNTP-Posting-Host: 141.157.87.18
X-Complaints-To: abuse@verizon.net
X-Trace: nwrddc02.gnilink.net 1021664319 141.157.87.18 (Fri, 17 May 2002 15:38:39 EDT)
NNTP-Posting-Date: Fri, 17 May 2002 15:38:39 EDT