extract month from date display date using extracted month

How to extract Month from Date and then displaying the date using that extracted month??

I want to display dates according to Month. I have only "Date" column in database table.

I used below queries but it is not working:

string query= "SELECT EXTRACT(MONTH FROM date) AS Month FROM HolidayTable";
DataSet ds = new DataSet(query)
int month = Convert.ToInt32(ds.Tables[0].Rows[0][0]);

and

string query2 = "select date from HolidayTable where date= '" + month + "' ";

please help.