db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Segel" <mse...@segel.com>
Subject RE: Derby Function
Date Tue, 07 Mar 2006 16:55:14 GMT


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. 

View raw message