Date function help subtracting dates

Question posted by: ananthaisin (Newbie) on August 16th, 2008 11:49 AM

I am having the below oracle statement

TO_DATE(to_char(last_day(add_months(sysdate-1,-1))+1,'dd-mon-YYYY'),'dd-mon-YYYY')-ACT_DATE

to update a column...

But in Db2 this does not work,i found a roundabout method or duno if its good..

days(((current_date - day(current_date) day)+1 day))-days(date(act_date))

The column is to be updated with the no of days from the start of the month(even if its 15th of the month)...

But how can i use last_day and add_months function in the above i am stuck at thissss...

Quote | Subscribe