Birthdate

Question

Post reply

Birthdate

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 1

datediff(YEAR, BirthDate, getdate())

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

You do realize that your code will only 25% of the time for individuals born on 2/29 of a leap year, right?

edward_hall76 SSC Eights! Points: 932 More actions · Answer 3

edward_hall76

SSC Eights!

Points: 932

September 14, 2013 at 8:17 pm

#1650256

did not notice that.

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 4

Erland Sommarskog (9/14/2013)
datediff(YEAR, BirthDate, getdate())

Doesn't work, Erland. Consider a baby born on 12/31 of some year and using your code the next day.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 5

Jeff Moden (9/15/2013)
Doesn't work, Erland. Consider a baby born on 12/31 of some year and using your code the next day.

In that case, there is some other bug. The proposition was that we had already selected people born on this day. That baby should not get a mail until 364 days later.

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 6

Erland Sommarskog (9/15/2013)
Jeff Moden (9/15/2013)
Doesn't work, Erland. Consider a baby born on 12/31 of some year and using your code the next day.
In that case, there is some other bug. The proposition was that we had already selected people born on this day. That baby should not get a mail until 364 days later.

Ah... got it. No complex age calculation required if you send it out on the birthday.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)