IBM Mainframe Forum

i am facing problem how we can find difference b/w current date and stored date(which was entered into table)

if dob, cur_date columns of table

select cur_date - dob as age from tablename

SELECT DAYS(CUR_DATE - DOB) FROM TABLENAME.
Hope it will work.

Thanks
Manikavasan.R

Hello,

It may work - we won't know because the request is quite non-specific. . .