View Single Post

   
  #4 (permalink)  
Old 05-07-2008, 11:15 AM
Tonkuma
 
Posts: n/a
Default Re: Date function in DB2 V8.1 for Z/OS

CURRENT DATE - (DAY(CURRENT DATE)-1) DAYS - 1 MONTH
or
CURRENT DATE - (DAYOFMONTH(CURRENT DATE)-1) DAYS - 1 MONTH
Reply With Quote