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 PM
To: Derby Discussion
Subject: Re: Derby Function


Sorry,   I mean GROUP BY YEAR(), MONTH(), DAY() in Derby.