Max Ten wrote: > Unfortunately there are no such functions in Derby... so i need to > store the number of year, month and day in different columns.
Which functions exactly are you looking for? YEAR, MONTH and DAY all exist in Derby 10.2 E.g. http://db.apache.org/derby/docs/10.1/ref/rrefyearfunc.html ij> values day(current_date), month(current_date), year(current_date); 1 ----------- 6 3 2006 Dan.
