db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: Derby Function
Date Tue, 07 Mar 2006 04:31:55 GMT
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.


Mime
View raw message