TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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...
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.
Reply
Answers (
10
)
Win32_SerialPort Class not working in Windows 8.1 Pro
Panels in Unity