Extract of year and date for grouping

Hi there,

I’ve succeeded in grouping rows of a report by year & month using the column definition:

SELECT SUBSTRING ( CAST (inv.datetime AS CHAR(10) DATE FORMAT ‘yyyy-mm-dd’), 1 FOR 7 ) AS _inv_year_month

This seems rather inelegant. Is there a simple way of doing this?

Thanks.