Axiell - Age from Date of birth SQL - Forum

Categories » MI » Age from Date of birth SQL

Age from Date of birth SQL

toggle

Age from Date of birth SQL	Steven Bannister	7/22/10 7:46 AM
RE: Age from Date of birth SQL	Simon J Dunlavey	9/24/10 8:34 AM

Steven Bannister Posts: 5 Join Date: 2/12/10 Recent Posts	Age from Date of birth SQL 7/22/10 7:46 AM Hi, I recently had to try and roughly work out the age of a borrower based on their date of birth in msquery to export into a pivot table. This is my solution. 1 2Age=(case 3length(char(date_trunc('day','today')-borrower_main.birth,10)) 4when 10 then 5int(left(char(date_trunc('day','today')-borrower_main.birth,10),5)/365.25) 6when 9 then 7int(left(char(date_trunc('day','today')-borrower_main.birth,10),4)/365.25) 8when 8 then 9int(left(char(date_trunc('day','today')-borrower_main.birth,10),3)/365.25) 10else '' 11end), It's not perfect as leap years can cause it to be out by a year. Does anyone else have a better way of doing this? Steve
	±0 (0 Votes) Sign in to vote. Flag Please sign in to flag this as inappropriate. Top

Simon J Dunlavey Posts: 1 Join Date: 9/24/10 Recent Posts	RE: Age from Date of birth SQL age date birth 9/24/10 8:34 AM as a reply to Steven Bannister. Hi, The following SQL will give you the borrower's age as a floating point number: select interval('year', date('today') - birth) from borrower_main for a borrower with a birth date of e.g. 14/04/87 this will return 23.447 if you just want a whole number of years then wrap the above in an 'int4()' conversion call: select int4(interval('year', date('today') - birth)) from borrower_main will return 23 Simon
	±0 (0 Votes) Sign in to vote. Flag Please sign in to flag this as inappropriate. Top

Calendar

Thursday

17

Time	Title	Type

There are no events on this day.

Showing 0 results.