Skip to Content
0
Mar 21, 2006 at 10:04 AM

select month() from a date field

1288 Views

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