|
Hi
I have a table listing people along with their date of birth (currently a nvarchar(25))
How can I convert that to a date, and then calculate their age in years?
My data looks as follows
ID Name DOB 1 John 1992-01-09 00:00:00 2 Sally 1959-05-20 00:0...
Started by James.Elsey on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Declare @DOB datetime 1 END AS Age
Used the datediff, but then modify it back down a year if the birthday has not yetSELECT ID, Name, DATEDIFF....
The day count but it fails on a leap year scenario and misreports the age by 1 day.
|
|
At the moment Lauren is 4 years old and Jenna is 8 years old. In how many years will the product of their ages?
Started by David clark on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at yahoo):
Solve for x using the quadratic equation....
Is there more to this question?
ie how many years untill the product = number of years from now
(4 + x) * (8 + x) = y
This is a quadratic equation in x.
Of their current age is 4 x 8 = 32.
|
|
Do any of you have children that are 2 years apart in age or less?
Started by edelweiss23 on
, 11 posts
by 6 people.
Answer Snippets (Read the full thread at cafemom):
The oldest just turned 9 and the ....
They went to each other's sports events to cheer.
How old are they? As they get last year they leaned on each other for support.
It has gotten worse since their dad deployed a year ago.
Or twice a week.
|
Ask your Facebook Friends
|
A new story entry has been added:
For Patients Older than 60 years of age, Cytogenetics and Age are a Major Determinant of Outcome in AML
[Quote: ]
Started by HCat on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at cancerfocus):
|
|
Retirement age increased by a few years - for or against ? The Spanish and German government are planning to increase the legal retirement age from 65 to 67 years old. Other European countries are considering the idea too.
With the declining birth rate...
Started by Maciamo on
, 23 posts
by 19 people.
Answer Snippets (Read the full thread at eupedia):
Although when I get there perhaps and so is the economy ! ... .
Two years should be enough year olds of today are in much better shape than those 40 years ago.
Live expectancy becomes higher, retirement age should increase too.
|
|
Hello, My beautiful dad has just been diagnosed with GBM after a seizure a couple of weeks ago, followed by complete tumour ressection on the right frontal lobe. The surgeon described its position as favourable as it was on a "overhang" on the brain they...
Started by rach@128 on
, 15 posts
by 6 people.
Answer Snippets (Read the full thread at cancerforums):
Aussie, ....
Hang in there.
Most will tell you Aussie.
His tumor had already are right, age does tend to affect the survival rate but so do a lot other factors.
I lost my father to GBM-IV almost exactly a year ago.
Are going though this.
|
|
When someone asks how old is baby...I think I'm done with months now...i always convert to years quick anyway when I ask about another baby. Just curious.
Started by themargo on
, 14 posts
by 14 people.
Answer Snippets (Read the full thread at thebump):
Then I use just turned two, two, two and a half, and almost three as my age estimates just turned two, two, two and a half....
I say year and a half now.
Just turned two, two, two and a half, and almost three as my age estimates.
|
|
Hi guys been reading these Forums for a while now and finally got the balls to show you what I have managed to work for, I am now planning an upgrade as I have decided to start saving as i got Employed as an Apprentice IT technician for Northgate Managed...
Started by Ferrari Joe on
, 12 posts
by 5 people.
Answer Snippets (Read the full thread at avforums):
And right speaker too wide apart? IMO they are anyway .
|
|
I've found the Toronto thread to be quite helpful, so I thought why not start one for the number one city in the world? And what better day for it than its 125th anniversary? I call on Vancouver-GAF to help make this OP a useful resource to anybody who...
Started by Firestorm on
, 50 posts
by 29 people.
Answer Snippets (Read the full thread at neogaf):
Vancouver-age eh? Time....
I visit once a year Society.
I so wish I lived there.
We get it vancouver, youre awesome
i need to visit sometime Should add English Bay to the beach section! It really is lovely .
Last year, beautiful city.
|
|
Hey guys, as you can see im new to this forum and this is my first post. After 2 months of starting a proper gym routine, today i measured my arm width at cold flex and found them to be just under 15" is this good for a 16 year old? I'm about 5'10 and...
Started by Saedd on
, 11 posts
by 9 people.
Answer Snippets (Read the full thread at bodybuilding):
Thanks people, i guess cause ive got a sort of stocky body it help with my overall bicep peak, and ive been on a proper bulking diet consuming... .
But my arms look small as fuaarrrkk, cuz I'm 6'2 .
I'm only 14.5' cold.
That's so awesome bro you're so big Congrats.
|
