[resolved] How to get age from date of birth

[_AnonymousUser]

Hi all,
How to calculate the age of a person from his date of birth

My table contains

Sno  Fname    DOB(numeric)

1      Shan       29081990

2      Hani        17071989

My output has to be

Srno  Fname  Age(varchar)

1         Shan        24

2         Hani         25

can some one help me to guide how to solve this

Regards,

Nare

[Anonymous]

A bit of Java is what you need.
http://stackoverflow.com/questions/1116123/how-do-i-calculate-someones-age-in-java

[Jcs19 · Accepted solution]

If you dont know java language
You can use tmap and create Variables 
transform your DOB(numeric) to a date with dateparse
then use datediff
check below

(care its Var.Fulldate not Var.fulldate, i made an error on the screenshoot)
tell me if you dont understand ! (I transform your interger to string, then your string to date)
If you get a negative number, then try TalendDate.diffDate(TalendDate.getCurrentDate(), Var.FullDate,"yyyy")