Hi all,

I have a char field Birthdate(YYYYMMDD) and I have to find the age of the person by substracting from CURRENT DATE. Can you please advice?

thanks

using the date(charfield) and current date and build in functions
you can find the nbr of days between 2 dates
if col1 char(8) and value would be YYYYMMDD
db2admin:/cygdrive/c/workdir: db2 select "col1,date(substr(col1,1,4)||'-'||substr(col1,5,2)||'-'||s
ubstr(col1,7,2)) - current date from tx"

COL1 2
-------- ----------
20060107 -2,

Thanks,

I tried
Current date - date(substr(BRTH_DT_CD,5,2)||'/'||substr(BRTH_DT_CD,7,2)||'/'||substr(BRTH_DT_CD,1,4))

getting the result in date.

But I want it in years meaning 27.6yrs for example.

thanks again...

An example :
values((current date - '2004-01-01')) is 20008.
values(year(current date - '2004-01-01')) is 2
values(month(current date - '2004-01-01')) is 0
values(day(current date - '2004-01-01')) is 8

Use this to calculate how you want to

HTH

Sathyaram