select posts depending on month

[piniyini]

I wanna make an archives section for my site, is there any way to select posts depending on the month. The posts have a date/time field in the db.

I think its gonna be something like this

select * from `table` where `date_time` = january

or some crap like that?

[discoverclips]

yeah seems good. something like SELECT content FROM table WHERE 'date'=january;

[piniyini]

yeh but date/time is in the format of 2005-09-28 09:53:06 - how do i select posts depending on the month?

[piniyini]

its ok guys i got it ;-)