I have a table and I want to extract data on the basis of the month value of the created date field. How can that be obtained?
Here is the query:

```
select *
from (table name a)
where select extract (month from a.createddate )from table name a 

```

Table contains a field with timestamp type.