select * from table where date_format(date_field, '%Y-%m') = '2006-02' bastien
From: "Gerry Danen" <gdanen@xxxxxxxxx> To: php-db@xxxxxxxxxxxxx CC: php_and_mysql@xxxxxxxxxxxxxxx Subject: 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. TIA. Gerry
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
