so any ideal how to unsubscribe? help please...
I had tried to unsubscribe by send a blank email to mailing address but didn't work.
Wish to know is there any option i can unsubscribe? Thank you.
Sorry, I mean GROUP BY YEAR(), MONTH(), DAY() in Derby.
Unfortunately there are no such functions in Derby... so i need to store the number of year, month and day in different columns.
if i'm not misunderstood your explanation, tats mean i have to store ex: 2006-10-31 to 3 different columns, (Yr) for 2006, (Mth) for 10 and (Dy) for 31.By this way i can use the function "GROUP BY" for those columns.
Anyway, will it be any enhancement for function "GROUP BY" in future?Thanks Stanl
Is there any function for - GROUP BY YEAR(), GROUP BY MONTH(), GROUP BY QUARTER() in derby?
CREATE TABLE t ( ts1 TIMESTAMP , ts2 TIMESTAMP NOT NULL DEFAULT '-00-00 00:00:00' );
INSERT INTO T (TS2) VALUES ('0001-01-01-00.00.00.00');
If execute the insert statement, ts1 column can be blank, but ts2 must have a valid datetime value.
So by using getTimestamp in java to retrieve fro
thank you, Jim.
thanks David, i try to get wat you mean.
Anyway, i just found some tutorial bout connecting to Derby using Netbeans. Is there any tutorial for Derby distribution using Netbeans ?
I have another question here, how to distribute my desktop application with derby? is there any feature in Netbeans? thanks.
10 matches
Mail list logo
