hi
i am using hibernate and oracle for my application

i need to make a query which return the difference between two date
i am using java.util.Date for the date property.

in details the problem is i need to know the age from the birth date.
how can i write a quey which will give me the difference between the birth date and the current date

Hi,

you should just get the current time in Millisecons with "System.currentTimeMillis()" and save it as a "long". Then get the date you wanted, get it's time in millis and subtract from each other. Now you have the difference in millis and you just need to divide until you have the unit you want.
Cheers,

Lutz