db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject how i can extract one element of DATETIME field in sql and use it ?
Date Mon, 28 Nov 2005 09:12:07 GMT
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 ?


Mime
View raw message