Viewing 1 post (of 1 total)
  • Author
    Posts
  • March 21, 2011 at 10:14 pm #31203
    clinicoffice_user
    Participant

      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.

    • Author
      Posts
    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.