ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> php-db
php-db
Re: [PHP-DB] Date question
by LJ Regalado other posts by this author
Mar 12 2006 8:12PM messages near this date
Re: [PHP-DB] Date question | [PHP-DB] Ye old $_SESSION variables :)
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
Attachments:
unknown1

Thread:
Gerry Danen
Gerry Danen
Bastien Koert
Gerry Danen
Chris
LJ Regalado

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved