how i can extract one element of DATETIME field in sql and use it ?

[Legolas Woodland]

Hi
Thank you for reply.
i get one field for each of a DATETIME element in my table.
it means that i have : year , month, day , hour, minute, second .
i do this to be able to use each element in my queries. i find that in 
Oracle it is possible to extract each of those elements in sql commands 
and use them.
now my question is how i can do the same (using a datetime and then 
access to each of the element) in derby ?