Perhaps I wasn’t being clear.
If you write your select statement to
include a “virtual” column(s) of YEAR(), MONTH() and DAY(),
You can then group by them.
From: Max Ten
Sent: Monday, March 06, 2006 10:40
To: Derby Discussion
Subject: Re: Derby Function
Sorry, I mean GROUP BY YEAR(), MONTH(), DAY() in Derby.