Re: Retrieve the month from a date field
| From: | Jason Wong | Date: | Wed, 09 Apr 2003 11:50:09 +0000 |
| Subject: | Re: Retrieve the month from a date field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26951@lists.php.net to get a copy of this message | ||
On Wednesday 09 April 2003 19:20, shaun wrote:
> I have a date field in my table (YYYY-MM-DD). Is it possible to retrieve
> all the rows that occur in a given month i.e. April?
mysql manual > MONTH()
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
It is the quality rather than the quantity that matters.
-- Lucius Annaeus Seneca
*/