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
Amudhan Kuppan
NA
378
29.5k
I have one doubt in sql
Mar 8 2018 12:03 AM
hi,
anyone help me how can i calculate the age in my table using sql
what can i query written i will send one image please note that
ALTER TABLE Student ADD Age AS DATEDIFF(YEAR, DateOfBirth, GETDATE())
this query can be written in my table
my problem is i will insert new record at dob column is ;1983-11-16' so it display age as 35
but iam checking age calculator website it display 34
correct answer is 34 i know what query can be written in sql become as 34 please help me
Attachment:
age.rar
Reply
Answers (
4
)
I have one doubt for sql
i have one doubt for Stored procedure