Hello,
In DB2 syntax, how would I extract the YEAR from a date column where I'm interested in the year of the previous month? In SQL Server syntax I would do it like this;

YEAR(DATEADD(MONTH,-1,GETDATE()))

From what I can tell, there is no equivalent DATEADD function available in DB2, and I must use CURRENT_DATE instead of GETDATE().

This is something I'm trying to do in SQL Server DTS where the source table is coming from a DB2 system.

Thank you for your help!

cdun2

try YEAR(current date - 1 month)

Andy

BINGO! Thanks!
cdun2