How to Calculate Age Using SQL

[BALLARI]

Hi everybody, I Have program in java. and a a table in sql which contains a field date_of_Birth . I would like to make a calculation on this date_of_Birth fields and displays the age of the person in java. the query I M Using is Query1 = "SELECT AVG (DATEDIFF (year, date_of_Birth, getdate ())) FROM Table 2 "; It worked in query analyzer and displays age. but when I try to Run in java. it does not. Does anyone have a java code or a class that allows me to do this? Thank you in advance.

[Modifier]

Hello , You Can Try With These Sql codes for getting the age of a person :

DECLARE @BirthDate DATETIME
DECLARE @CurrentDate DATETIME

SELECT @CurrentDate = '20070210', @BirthDate = '19790519'

SELECT
DATEDIFF(YY, @BirthDate, @CurrentDate) -
CASE
WHEN(
(MONTH(@BirthDate)*100 + DAY(@BirthDate)) >
(MONTH(@CurrentDate)*100 + DAY(@CurrentDate))
) THEN 1
ELSE 0

[MindSpace]

You can use a SELECT query rather than a cursor by substracting the birthdate from the system date. use different functions for determining the current date and for extracting parts of dates. For example, to retrieve the system date, DB2 uses CURRENT DATE, Oracle uses SYSDATE, SQL Server and Sybase use GETDATE.

[zakirhussain]

hi please help me iam student i know how to creat database in sql i dont know how can i make interface for sql