var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Getting YEAR as of prior month
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;
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!
try YEAR(current date - 1 month)