get records between start day of a month and end day of the month

Question

hi friends,i need a database query to retrieve records between the start day of a month and the end day of a month...i have two fields in my table(status,date)...can you people tell me how can i accomplish what i required???

Answer 1

Select * from tablename where to_Char(Date,'MM')=12 and to_Char(Date,'YYYY')=2008
here 12 stands for december...