Gerry Danen wrote:
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.
Which database are you using?
Mysql has this:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
Postgresql has:
http://www.postgresql.org/docs/8.1/static/functions-datetime.html
I'm sure others have the same sort of functionality.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
