Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Calculating age Rate Topic Display Mode Topic Options
Author
 Message
 Posted Friday, September 20, 2013 3:36 PM
 SSC Journeyman Group: General Forum Members Last Login: Today @ 8:34 AM Points: 75, Visits: 2,154
 This seems to work`DECLARE @DOB DATETIMESET @DOB='9/19/2000'SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)`
Post #1497062
 Posted Friday, September 20, 2013 3:55 PM
 SSC-Forever Group: General Forum Members Last Login: Today @ 3:23 PM Points: 42,036, Visits: 39,415
 gilbert delarosa (9/20/2013)This seems to work`DECLARE @DOB DATETIMESET @DOB='9/19/2000'SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)`Good try but it doesn't work...`DECLARE @DOB DATETIMESET @DOB='01/01/2013'SELECT FLOOR(DATEDIFF(DD,@DOB,'01/01/2014')/365.25)``Results:---------------------------------------0(1 row(s) affected)` --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." Helpful Links:How to post code problemsHow to post performance problems
Post #1497067
 Posted Friday, September 20, 2013 4:01 PM
 SSC Journeyman Group: General Forum Members Last Login: Today @ 8:34 AM Points: 75, Visits: 2,154
 But they wouldn't be 1 until after their BDayor you could just `DECLARE @DOB DATETIMESET @DOB='01/01/2013'SELECT FLOOR((DATEDIFF(DD,@DOB,'01/01/2014')+1)/365.25)`
Post #1497069
 Posted Friday, September 20, 2013 5:01 PM
 SSC-Forever Group: General Forum Members Last Login: Today @ 3:23 PM Points: 42,036, Visits: 39,415
 gilbert delarosa (9/20/2013)But they wouldn't be 1 until after their BDayor you could just `DECLARE @DOB DATETIMESET @DOB='01/01/2013'SELECT FLOOR((DATEDIFF(DD,@DOB,'01/01/2014')+1)/365.25)`Still doesn't work. Last I heard, you gained a year on your birthday and not the day before (Feb 29 babies sometimes excluded). `DECLARE @DOB DATETIMESET @DOB='01/01/2012'SELECT FLOOR((DATEDIFF(DD,@DOB,'12/31/2012')+1)/365.25)``Results:---------------------------------------1(1 row(s) affected)` --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." Helpful Links:How to post code problemsHow to post performance problems
Post #1497080
 Posted Friday, September 20, 2013 6:15 PM
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 2:30 AM Points: 2,192, Visits: 7,773
 `declare @dob datetime,@now dateset @dob='1 jan 2012'set @now = '31 dec 2012'select datepart(year,@now) - datepart(year,@dob) + case when dateadd(day ,datepart(day,@dob)-1 ,dateadd(month ,datepart(month,@dob)-1 ,dateadd(year ,datepart(year,@now)-1800 ,'1 jan 1800' ) ) ) > @now then -1 else 0 end` MM`select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);`Forum Etiquette: How to post Reporting Services problemsForum Etiquette: How to post data/code on a forum to get the best help - by Jeff ModenHow to Post Performance Problems - by Gail Shaw
Post #1497088

 Permissions