var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 SQL to get most recent FULL six months + what ever days are in the current month
In the where clause i am doing the following....
MYDATE >= CURRENT DATE -6 MONTH
This returns six months of data but its exactly 6 months. So its including part of Novemember and part of May 2014.
My goal is to get the entire most recent six months and what ever partial days are in the current month.
So May, June, July, August, September, October & whatever days are in Novemember so far. If I ran it today 11/12
MYDATE >= current date - (day(current date) - 1) days - 6 months