dates in MYSQL
| From: | Alex Francis | Date: | Wed, 17 Apr 2002 08:40:18 +0000 |
| Subject: | dates in MYSQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18587@lists.php.net to get a copy of this message | ||
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.