Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2009-03-02 : 06:58:26
|
| Hi all,can you help me in age calculation.. when provided dob.sp should load data for one month, in parameter will always beDD=01 MM=Any YYYY=Any eg( 01/12/1989 or 01/11/2001 etc...)means complete date with 1st of any month [purple][b]Proc Age_cal @start_of_month_date datetimeasBeginDeclare @tmp_dateset @tmp_date=@start_of_month_date -- in parameter dateWhile @tmp_date < dateadd(mm,1,@start_of_month_date)begin Insert into #temp_tab select xyz.id,@tmp_date,AGE /*needs to calculate*/,abc.dob, is_birthday/* needs to check if it is b'day then 1 else 0*/ from abc join xyz on abc.id=xyz.idendend[\b][\purple]I did used datediff(yyyy,dob,@tmp_date) but not working..I want age in whole number say if the person is 11 months old then age = 0 if he is 1year 11 months then it should give me 1year agethe temp_date should cross his b'day or should be equal to b'day to increament the age.kindly help.. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-03-02 : 07:18:59
|
| see some solutions are given in this http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=120499 |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
age calculation