find age using query in textbox

Apr 7 2021 7:30 AM

how can i find age of user when enter date like "23/03/1982" then age should be display in textbox using sql query.

actualy i want to find age using server date. by sql query....

how to implement using sql query...

below is my query how can i implement this query to vb6.0 project...

select DATEDIFF(YEAR,CONVERT(datetime,'23/03/1993',103),CONVERT(datetime,GETDATE(),103))

Textbox1 is for date. date should be dd/MM/yyy

Textbox2 is for age.

Answers (10)