finding in between date

[prashant6388]

i hav a table(emp) in sql containing dates stored in date-time format.
(e.g. 11/11/2002, 13/12/2003, 20/11/2003 as dd/mm/yyyy )
now i want to find those records which has month=11.

database is mysql.

please suggest me a query to retrieve those records.

[WingedPanther]

What database type? Oracle, SQL Server, and MySQL are quite different for this sort of thing.