select month() from a date field

Hi,

How can I get the month from a day field in select statement ?

e.g.

select month(erdat), count(*) from vbak group by month(erdat).

Thanks

Wilson