select * from table where date_format(date_field, '%Y-%m') = '2006-02'


From: "Gerry Danen" <[EMAIL PROTECTED]>
Subject: [PHP-DB] Date question
Date: Sun, 12 Mar 2006 20:44:13 -0700

While I am rebuilding my crashed laptop (the machine that had all my
intelligence), I started thinking about a select statement I need.

I have log info in a table and want to extract it on a monthly basis. The
date field is in yyyy-mm-dd format. What's a good way to select those dates
that match 2006-02, for example.

I apologize if the solution should be staring me in the face, but all my
favorites and help files are toast, until I can restore some of them.



PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to