Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Function Help

Status
Not open for further replies.
pradchal1

pradchal1

Programmer
Nov 10, 2004
31
FR
What is the SQL function to get the age from a birthdate?

I know in MS ACCESS, it is
DateDiff("yyyy",BIRTHDATE,Now())

Thanks
 
Sort by date Sort by votes
Almost the same:

Code: 
 DateDiff(yy,BIRTHDATE,getdate())



"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M. [hourglass]

 
Upvote 0 Downvote
Calculating age is not at all straight forward. Take a look at this thread thread183-1010795 solutions are presented there.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
544
Chriss Miller
C
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
652
Chris Miller
Chris Miller
f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
589
f0rg3tfu1
f0rg3tfu1
grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
1K
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top