Bhavesh Vankar

Bhavesh Vankar

  • 753
  • 1.2k
  • 89.3k

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...
  1. 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)