Re: Date question
| From: | LJ Regalado | Date: | Mon, 13 Mar 2006 04:11:38 +0000 |
| Subject: | Re: Date question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41469@lists.php.net to get a copy of this message | ||
For example, you have table
logs with datelog field and you want to
select dates
that match 2006-02. You can try this select statement:
SELECT * FROM logs WHERE MONTH(datelog)='02' and
YEAR(datelog)='2006'
Hope that helps.
LJ Regalado