Originally Posted by nick.ncs
I guess thats how you do in MS SQL Server.... there is no dateadd function in db2
nick has added "52 years" and not just 52.... there is a difference... in DB2 you can directly add days ( eg. date + 10 days ) , months ( eg. date + 10 months) and years just like arithmetic addition
The statement actually worked for me in DB2:
Birthdate + 52 Years as AGE 52_DATE
The only problem left is that it returns the month, day and year.
3-16-1960 returns 3-16-2012
I just need the year. I think there is a YEAR function that will point me in the right direction. Any ideas?