Max,

 

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 [mailto:max.tenwl@gmail.com]
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.