how use group by with date

[Rahul Gupta]

I am trying to use group by month , month is extracting from Date column but extract function not working, can anyone help me?

[gun...@oliveindesign.com]

"SELECT  mydate FROM TABLE__VIEW__HISTORY" + " GROUP BY " + "TABLE__VIEW__HISTORY.mydate";