How to get the month part of an Oracle date field?

Hi all,

To give me the total number of workdays in a month, I'm trying to write a query along the following lines:

SELECT COUNT(something_not_null)

FROM table_with_dates_and_holidays

WHERE

	is_weekday = 1 AND
	is_not_holiday = 1 AND
	the_month_part_of_AS_OF_DATE = [1-12] or [Jan-Dec] or [what the hell

The field as_of_date is a date field. How do I get the month-part of it, to test for equality with the input?

Thanks for any hints,

cdj Received on Mon Mar 19 2007 - 17:38:01 CDT