Re: dates in MYSQL

>SELECT From the database WHERE date >= todays date. Should work. I've you tried it? Mike ----- Original Message ----- From: "Alex Francis" <afrancis@camerondesign.co.uk> To: <php-db@lists.php.net> Sent: Wednesday, April 17, 2002 4:40 AM Subject: [PHP-DB] dates in MYSQL > This may be a stupid question but I am a complete newbie. > > I am trying to automatically drop events from a noticeboard when the date > has passed. I have stored the date of the event in the database in the form > YYYY-MM-DD and wish to SELECT From the database WHERE date >= todays date. > Is this possible or do I need to INSERT todays date into the database first. > > -- > Alex Francis > Cameron Design > 35, Drumillan Hill > Greenock PA16 0XD > > Tel 01475 798106 > afrancis@camerondesign.co.uk > http://www.camerondesign.co.uk > > This message is sent in confidence for the addressee only. It may contain > legally privileged information. > Unauthorised recipients are requested to preserve this confidentiality and > to advise the sender > immediately of any error in transmission. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02