Previous Discussion	Next Discussion

NOW() +1 Probably a really simple one but I'm stuck I can select records from a recordset based upon dates up until today - SELECT * FROM events WHERE events.eventDate>=NOW() ORDER BY events.eventDate But that misses out any records for TODAY!! I tried variations on NOW()+1 but am stuck and can find no online reference to it whichreally surprised me as I assume this must be a common requirement!? Any pointers? Started By Jockrock on Oct 23, 2009 at 8:22:51 AM

4 Response(s) | Reply

View All Replies

Terry Young on Oct 29, 2009 at 10:46:16 AM It's interesting, to think of it now, that I never knew nor used CURDATE() for all these years. I simply rely on PHP or ASP or whatever, and inject the date literal into the SQL statement.

View All Replies

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.