Thread: Date function in DB2 V8.1 for Z/OS
View Single Post

   
  #1 (permalink)  
Old 05-07-2008, 10:15 AM
JAW
 
Posts: n/a
Default Date function in DB2 V8.1 for Z/OS
I need to get the first day of the previous month in a query.

I thought CURRENT DATE and DAYOFMONTH would allow me to da it but it
is noe

WHERE DTXL >= 1st day of previous month


Anyone got a good idea?
Reply With Quote