PLease Help Get Age FRom DAte

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im making this stored procedure to return the age of the user to the web
control but the problem is that DATEPART(). I can only Specify one and i need
the age to to the exact format of mm dd yy but i cant get it into the Query
so it can execute. And when I use the yyyy to return the Age it returns the
age as between 1 - 11 months and between 1 - 364 days. So for example the
user was
borned 21.11.85. when executed it returns the user is 20 when their 20th is
4months away.

<SQL QUERY>
SELECT DATEDIFF(yyyy, Dob, GETDATE()) AS Age
FROM Basic
WHERE (UName = @UName)
 
I'm not sure this would be acceptable in your situation as it's not exact -
but why not get the number of days old they are and divide by 365. That
should get you a years value that reflects the fact they may not have hit
their birthday yet this year.

Of course leap years throw this calculation off, but still should be pretty
close.
 
hi

was this a repeated post? included your correction
SELECT DATEDIFF(d, Dob, GETDATE()) / 364 AS Years,
( 12 - ( datepart(m, dob) - datepart(m,getdate()))) % 12 AS Months
FROM Basic
WHERE (UName = @UName)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP GET AGE FROM DATE 3
Please Help Me Get The Age From The Birthdate 2
calculation of age from date of birth 3
Age 9
calculate Age problem date notation european american format 2
Rounding Down of Age 1
Age from Date Function 5
subtracting 2 dates to calculate age; format as years days 4

Back
Top